showing highest value.

[#1]

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

[jagan · Accepted solution]

Hi, 

Please check the attachment for solution.

Hope this helps you.

Regards,

Jagan.

[matt_crowther]

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

[#4]

nice...... thnks