Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pie chart dimensions

Dear All,

              In a pie chart how to limit the number of dimensions. For example I have some dimendions like AIX,Solaris,Windows,Linux........etc i want to limit the dimensions in my pie chart display

                                              How can we do this???????

5 Replies
swuehl
MVP
MVP

I guess you could use a calculated dimension, like

=if(match(DIMENSIONFIELD,'AIX','Linux'),DIMENSIONFIELD)

to filter AIX and Linux only.

jonathandienst
Partner - Champion III
Partner - Champion III

And on the dimension, set "Suppress when Value is Null"...

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanx swuehl/Jonathan,

                                  Its working perfectly,, but am getting the expression in pie chart how to hide that exp....

swuehl
MVP
MVP

I think you could use the label field on tab dimension.

Not applicable
Author

swuehl got it....thnx for your help

I have another requirement like i want to show the release verisons of AIX,Solaris,HP-UX...etc in different charts not in the same chart, in database we have 2 columns like OStype(AIX,Solaris...etc) and Release Version(5.1,5.2,5.3....for AIX) and(5.9,5.10,9...for sloaris).......etc. can i use in if condition all these versions separatly?????