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

Click on KPI to Open a URL in Qlik Sense

amithmurali — Tue, 15 Nov 2016 07:36:58 GMT

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

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

migueldelval — Tue, 15 Nov 2016 08:12:04 GMT

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

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

shraddha_g — Tue, 15 Nov 2016 08:21:08 GMT

You can use Qlik Branch to navigate to different app.

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

amithmurali — Tue, 15 Nov 2016 08:45:21 GMT

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

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

amithmurali — Tue, 15 Nov 2016 08:45:54 GMT

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

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

amithmurali — Tue, 15 Nov 2016 08:48:17 GMT

Hi Shraddha,

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

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

migueldelval — Tue, 15 Nov 2016 09:00:54 GMT

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

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

amithmurali — Tue, 15 Nov 2016 09:26:52 GMT

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. !

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

shraddha_g — Tue, 15 Nov 2016 09:38:39 GMT

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

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

amithmurali — Tue, 15 Nov 2016 09:40:56 GMT

I did the same but its not getting imported.

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

shraddha_g — Tue, 15 Nov 2016 09:46:11 GMT

It works great at my server.

DO you have any extension imported with same name?

what is the error you are getting while importing?