topic Re: showing highest value. in QlikView

showing highest value.

Tue, 07 Feb 2012 10:11:13 GMT

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

Re: showing highest value.

jagan — Tue, 07 Feb 2012 10:41:47 GMT

Hi,

Please check the attachment for solution.

Hope this helps you.

Regards,

Jagan.

showing highest value.

matt_crowther — Tue, 07 Feb 2012 10:41:54 GMT

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

showing highest value.

Wed, 08 Feb 2012 09:57:23 GMT

nice...... thnks