topic Re: Problem with If expression in Pie chart in QlikView

Problem with If expression in Pie chart

Wed, 25 Nov 2020 16:16:04 GMT

Hello Guys,

I have a query regarding the Pie Chart . As per my scenario I have to segregate the values of pie as follow

If srnumber is =1 then One

If srnumber is =2 then Two

If srnumber is =3 then Three

If srnumber is >=3 then 'All'

first 3 condition can be achieved but in the last case I am unable to rectify the issue or what is going wrong.

Thanks in advance , any help is appreciated.

Re: Problem with If expression in Pie chart

neelamsaroha157 — Mon, 19 Sep 2016 18:39:55 GMT

Check this out

Re: Problem with If expression in Pie chart

robert_mika — Mon, 19 Sep 2016 21:25:31 GMT

I believe the calculation dimension should say:

=If(srnumber >3 ,'All', srnumber)

BTW: Calculated dimension are not very efficient.

it would be better to create a new field at the script level using the same logic

Load:

If(number >3 ,'All', srnumber) As YourPreferedName

Feeling Qlikngry?

How To /Missing Manual(25 articles)

Re: Problem with If expression in Pie chart

Tue, 20 Sep 2016 13:02:27 GMT

Hello Neelam,

1st of all thanks for reply. the condition which you used by that we can not see that how many records are there in the specific pie. Hence, it is partially correct to get the desired output. By the way I get the solution by adding calculated field as below.

=if(Srnumber=3 ,3,
if(Srnumber=1 ,1,
if(Srnumber=2 ,2,
if(Srnumber>=3 ,'All',
))))

Re: Problem with If expression in Pie chart

neelamsaroha157 — Tue, 20 Sep 2016 16:02:16 GMT

So did it work or you are still working on the measure part???

Re: Problem with If expression in Pie chart

robert_mika — Tue, 20 Sep 2016 21:47:45 GMT

Sorry for being picky:

Is that really correct?

=if(Srnumber=3 ,3,
if(Srnumber=1 ,1,
if(Srnumber=2 ,2,
if(Srnumber>=3 ,'All',
))))

Re: Problem with If expression in Pie chart

Wed, 21 Sep 2016 04:56:55 GMT

Hello Robert ,

Yes It is correct.we have to create calculated dimension using the above formula and in expressions we have to give the count for srnumber (i.e. Count(srnumber)).

Re: Problem with If expression in Pie chart

Anil_Babu_Samineni — Wed, 21 Sep 2016 06:31:47 GMT

Does Robert Mika Expression suitable for you?

Or exactly, see this

=If(srnumber =1,'One',If(srnumber =2,'Two',If(srnumber =3,'Three',If(srnumber >3,'All'))))

Re: Problem with If expression in Pie chart

robert_mika — Wed, 21 Sep 2016 21:33:00 GMT

My concern was related to the calculation:

Yuu got >=3 and =3.

This way some of the values are being calculated twice.