Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
CA 4800 5000
NY 3000 5000
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
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