Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Add-hoc reports

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?

6 Replies
its_anandrjs

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.

ashfaq_haseeb
Champion III
Champion III

Hi,

Look at the below post.

http://community.qlik.com/docs/DOC-5404

Regards

ASHFAQ

Anonymous
Not applicable
Author

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.

tresesco
MVP
MVP

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.

Anonymous
Not applicable
Author

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

cjzimm76
Partner - Creator
Partner - Creator

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.