Are you using Tableau Server? If so, you can use a dashboard URL action to jump to the appropriate detail workbook. Let me know if you are using Tableau Server, and I'll be glad to give you more details...
I will be using tableau server and publishing it to server for users to use. But can we not do this using desktop?
The destination dashboards have to be published. The source from which you launch does not. the only way for a dashboard to have a URL is if it is published.
If you are looking to do actions based on the value of a measure (your description is not clear on that) you're going to find that difficult to do.
Uploading a sample workbook will help people help you with this.
One last thing: If you put all these dashboards into one workbook, you won't need hyperlink URL. You would be able to use filter actions, and then yes, you can do it all within desktop.