topic Pie chart dimensions in QlikView

Pie chart dimensions

Thu, 25 Aug 2011 10:00:52 GMT

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???????

Pie chart dimensions

swuehl — Thu, 25 Aug 2011 10:09:01 GMT

I guess you could use a calculated dimension, like

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

to filter AIX and Linux only.

Pie chart dimensions

jonathandienst — Thu, 25 Aug 2011 10:37:31 GMT

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

Jonathan

Pie chart dimensions

Thu, 25 Aug 2011 11:24:33 GMT

Thanx swuehl/Jonathan,

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

Pie chart dimensions

swuehl — Thu, 25 Aug 2011 11:27:42 GMT

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

Pie chart dimensions

Thu, 25 Aug 2011 12:02:16 GMT

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?????