Dynamic KPI Display

[amars]

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 

[hector_munoz]

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,

H

[amars]

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.

[karthiksrqv]

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

[amars]

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