topic Re: Dynamic KPI Display in QlikView

Dynamic KPI Display

amars — Thu, 30 Mar 2017 02:42:33 GMT

Hi All,

I have a requirement where I need to display the KPI's /Metrics as the user select the list of KPI's.

This is different from the Pivot table where user's conditionally display/hide Column's/Expressions.

Have attached an example on how I am willing to do it.

My issue is when a user select's one KPI it works perfectly but when user select's more than one KPI it doesn't displays the required Titles.

Kindly note that I have more than 30 KPI's but at max user will only select 4-5. Thanks in advance.

Best Regards

Amar

Re: Dynamic KPI Display

hector_munoz — Thu, 30 Mar 2017 04:08:12 GMT

Hi Amar,

Looking at yor QVW sample and at the excel file it seems that everything works fine... Could you explain what should appear instead of what the app is showing now?

Regards,

Re: Dynamic KPI Display

amars — Thu, 30 Mar 2017 09:13:20 GMT

Hi Munoz,

I was able to solve the issue using Set Analysis to display the Titles for the dynamic KPI's.

Please find the attached App now I am displaying the different metrics that needs to be displayed as the KPI's are selected.

Now I have another issue I have variable names stored as field values. Now I can extract the Field values but it doesn't act as a variable even when I append '$(' & end it with ')'. Not sure how to make it work.

Any ideas how to make field values which are variable names to work as variables? Thanks in advance.

Re: Dynamic KPI Display

karthiksrqv — Thu, 30 Mar 2017 10:31:35 GMT

You'd probably have to create counterpart variables, that will fetch the field value. The variable will then contain the value.

Re: Dynamic KPI Display

amars — Fri, 31 Mar 2017 00:55:22 GMT

Thanks Karthik, I thought of that but was little hesitant to have variable holding variable names. Will try and see how it works. Thanks again....