topic Re: pie chart in QlikView

pie chart

Thu, 08 Jan 2015 12:11:41 GMT

Hi,

Pie chart normally show the relation between a single dimension and a single expression.Is it possible if I want to show only required data in that dimension?I mean,if in one column there are Inprogress,Pending,Closed and I want to show only pending and progress.Is it possible?If so,how?

Re: pie chart

Anonymous — Thu, 08 Jan 2015 12:21:41 GMT

You can use calculated dimension, like this:

aggr(if(match(FieldName('Pending','Inproggress'),FieldName)),FieldName)

And, you have to suppress wen value is null

Or, just select the values you want...

Re: pie chart

terezagr — Thu, 08 Jan 2015 12:23:50 GMT

Hi,

see attached example

Re: pie chart

Thu, 08 Jan 2015 12:28:12 GMT

Hi,

Yes it is possible

1. You can use filter in set analysis expression

Ex: =Count({<Column={'Pending','In progress'}>}Column) // It will return the Pending and In progress counts

Where column will be your actual column which holds In progress,Pending,Closed.

2. You can use a calculated dimension as well

Hope it helps you..

Regards,

Ravikumar

Re: pie chart

arulsettu — Thu, 08 Jan 2015 12:29:47 GMT

Try like this

if(match(field,'Pending','Inproggress'),field)

in calculated dimensions

Re: pie chart

kiranmanoharrode — Thu, 08 Jan 2015 12:32:33 GMT

Hi Ramya,

Mention your required dimension values in set analysis.

for ex.

=Sum({<Stock_Status={"Pending","Inprogress"}>} Stock)

Regards,
Kiran

Re: pie chart

agomes1971 — Thu, 08 Jan 2015 12:33:24 GMT

Hi,

like this?