Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

amithmurali
Contributor

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
Valued Contributor

Re: Click on KPI to Open a URL in Qlik Sense

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
Honored Contributor III

Re: Click on KPI to Open a URL in Qlik Sense

You can use Qlik Branch to navigate to different app.

amithmurali
Contributor

Re: Click on KPI to Open a URL in Qlik Sense

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')))

Highlighted
amithmurali
Contributor

Re: Click on KPI to Open a URL in Qlik Sense

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
Contributor

Re: Click on KPI to Open a URL in Qlik Sense

Hi Shraddha,

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

migueldelval
Valued Contributor

Re: Click on KPI to Open a URL in Qlik Sense

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
Contributor

Re: Click on KPI to Open a URL in Qlik Sense

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
Honored Contributor III

Re: Click on KPI to Open a URL in Qlik Sense

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
Contributor

Re: Click on KPI to Open a URL in Qlik Sense

I did the same but its not getting imported.