Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Expert,
I have more than 50 kpi metrics.
I want to display all selected metrics in chart.
Is there any work around instead of conditional hard code for each metric?
Adhoc reports is the best option for this and you have to use this KPI formulas and use straight table for this also you can refer the sample app if you are using the QV11 ver and on samples you can find in the Whats New in the Qlikview file.
Thanks for reply guys.
I knew how to add conditional dimensions and measures.
But I want to add expressions dynamically in chart depend on user selection.
that is add expression on the fly depend on selections.
Load an island like:
Load Exp Inline [
Exp
Sum
Avg
];
Now allow users to select from Exp field. Say, if user selects Sum, you would like to make Sum(...) expression visible, in that case for your expression write the conditional expression like: =Max(Index(Exp, 'Sum')) and similarly for other expressions as well.
Hi Kiran,
check this awesome post - very good approach and all you metrics can be loaded to island table from excel spreadsheet - so no hardcoding. I also hate QV examples that came with QV 11 because they hardcode a lot of stuff so the approach below will be your best bet.
Customisable Straight (and Pivot) Tables - more food for thought
I used something similar to this except I pass the KPI formula from the separate excel file into a QV table and then into a variable once the user selected which KPI they wanted to see.