Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
vsap2000
Creator
Creator

Passing the values to open URL

Hello Guys,

I have a dashboard  with table which checks Curr Mth value against target accordingly it shows traffic light shown below, 

State Name    Curr Mth ($000's)   Target       Target Chk

AL                         6000                        5000           vsap2000_0-1639432031834.png

CA                         4800                         5000                   vsap2000_2-1639432144828.png

NY                         3000                           5000                    vsap2000_3-1639432293587.png

For Dot I have used Chr(11044) as measure. 

User like to open an app (using URL) when he clicks on any color for that particular state name, I used following code 

'MY URL/sheet/sheet id/state/analysis'& '/select/' & GetCurrentSelections(']/select/','/[','];[',50) & ']'.

For instance, user wants to know why it's red for NY when they click it should open the app with filter passed for NY. 

With the code above I have to filter  first, on State Name (or couple more fields) and then click on any dot and it opens the app with the filtered state name (or couple more fields). It is 2 step process is it possible it can be achieved with one step? 

 

Hope to get solution.

Thanks in advance.

-V

1 Reply
Andrei_Cusnir
Specialist
Specialist

Hello,

 

Please follow up in the post here [1], as it is already addressed there. 

---

[1] https://community.qlik.com/t5/New-to-Qlik-Sense/Open-URL/m-p/1870437#M197051

Help users find answers! Don't forget to mark a solution that worked for you! 🙂