Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have drill down dimension including Authority and head.
when I select any authority(e.g IT) table drill into four head belongs to IT (e.g IT-01,IT-02,IT-03,IT-04)
showing percentage of expense in each head.
table looklike IT-01 25%
IT-02 20%
IT-03 30%
IT-04 25%
I want to create new bar graph to show only the highest head and its actual figure.when somone select IT.
|
|
|______________________
IT-03 |______________________| $ 4933222
|
|
|____________________________
TOP MOST UTILIZATION
Hi,
Please check the attachment for solution.
Hope this helps you.
Regards,
Jagan.
Hi,
Please check the attachment for solution.
Hope this helps you.
Regards,
Jagan.
Sounds as though you need the aggr() function eg: =max(aggr(sum(Sales),Head)) - that will give you the maximum Sales per 'Head' aggregated across the Head dimension, when someone drills to IT it will show only those Sales within IT.
That may not fit your model perfectly but aggr() is definitely where you should start looking.
All the best,
Matt - Visual Analytics Ltd
Qlikview Design Blog: http://QVDesign.wordpress.com
nice...... thnks