topic Pie chart dynamic Dimension Limits in QlikView

Pie chart dynamic Dimension Limits

Mon, 30 Sep 2013 10:40:20 GMT

Hi Experts ,

I am new to Qlikview tool..

I Have one requirement like " Top N material which has max repair calls ". so I developed one static Pie chart .but client wants dynamic pie chart

based on parameter Pie chart should display.

For Example : Top 10 material which has max repair calls.

Result Expecting is...

Pie chart should display only Top 10 material

Please Give me any suggestions.

Regards,

Vinod

Mon, 30 Sep 2013 12:12:22 GMT

As a dimension use

=IF (Aggr(Rank(Count([Repair Calls])), Material) <= $(vTopn), Activity, Null())

The expression:

Count([Repair Calls])

In which $(vTopn) is the variable where the top n can be set

Mon, 30 Sep 2013 12:27:12 GMT

Hi Erik van Hout,

Where i have to write the " $(vTopn) " in script level or pie chart level.

I am new to Qlikview tool..Hence Could you please guide me..

Regards,

Vinod