Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amithmurali
Partner - Creator II
Partner - Creator II

Click on KPI to Open a URL in Qlik Sense

Hi guys,

I have a requirement in qliksense.

i have 4 apps namely Dashboard, Hospital, Trading and Pharmacy.

In the dashbaord app, i am combining all the Sales amount from hospital,trading and Pharmacy.

I have a field in Dashabord which is 'Type' and it contains values Hospital, tradiing and pharmacy. by default in the dashboard, it will show the complete sales and if i select hospital from the dimesion type. it will show only hospitals sales.

Now the requirement is that,

when the hospital is selected and if the customer clicks on the KPI, it should open the URL which contains the url to hospital app, or if he have selected trading, it should open the trading app.

In text object when i add measure and add url to it. i cannot give any if condition to point to it to dashboard.

Can you guys help me with this,

Thanks in Advance.

Amith

10 Replies
migueldelval
Specialist
Specialist

Hi Amith,

You could make diferents objects with differents actions/triggers (open URL). Your URL are going to be different for each select, because your object are going to be different too.

Regards

Miguel del Valle

shraddha_g
Partner - Master III
Partner - Master III

You can use Qlik Branch to navigate to different app.

amithmurali
Partner - Creator II
Partner - Creator II
Author

Hi Miguel,

Thanks for the reply,

What i want to achieve is something like this,

There is a KPI to show Total Sales. And when they select Hospital from the Dimension and click on the KPI it should goto Hospital Dashbaord.

So i want to achieve like this in the URL,

if(GetSelectedCount(Type) = 1,

    if(GetfieldSelections(Type) = 'Hospital' , URL of Hospital ,

       if(GetfieldSelections(Type) = 'Trading' , URL of Trading , 'URL of Pharmacy')))

amithmurali
Partner - Creator II
Partner - Creator II
Author

I want to achieve like this in the URL,

if(GetSelectedCount(Type) = 1,

    if(GetfieldSelections(Type) = 'Hospital' , URL of Hospital ,

       if(GetfieldSelections(Type) = 'Trading' , URL of Trading , 'URL of Pharmacy')))

amithmurali
Partner - Creator II
Partner - Creator II
Author

Hi Shraddha,

I tried to install the "Sense-Navigation" extension but it is not getting installed. in both the destop and server versions.

migueldelval
Specialist
Specialist

Hi Amith,

Try it:

if(

     GetSelectedCount(Type) = 1 and GetfieldSelections(Type) = 'Hospital' ,

     URL of Hospital ,

     if(

          GetSelectedCount(Type) = 1 and GetfieldSelections(Type) = 'Trading' ,

          URL of Trading ,

          if(

               GetSelectedCount(Type) = 1 and GetfieldSelections(Type) = 'Pharmacy' ,         

               URL of Pharmacy

               )

          )    

     )

Regards

Miguel del Valle

amithmurali
Partner - Creator II
Partner - Creator II
Author

Dear Miguel,

The if condition is correct but when i put it in the URL, it is not working.

Please find the attached app. I want to add the URL to the Sales Value so when he selects hospital and click on the amount , it should goto hospital Dashboard. !

shraddha_g
Partner - Master III
Partner - Master III

You dnt have to install it.

In server import file in Extension section

in Desktop unzip file in Extension folder C:\Users\Username\Documents\Qlik\Sense\Extensions

amithmurali
Partner - Creator II
Partner - Creator II
Author

I did the same but its not getting imported.