Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pie chart dynamic Dimension Limits

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


2 Replies
Not applicable
Author

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

Not applicable
Author

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