topic Re: Calculated Expression in QlikView

Calculated Expression

shinnickr — Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I have been looking around but for some reason am having trouble finding the syntax for what I'm looking for.

I have a dimension "PCI Flag" and it can either be flagged "Yes" or "No". I have a doughnut chart just showing the two fields and as "Text in Chart" I would like to have a calculated expression showing the % of "Yes".

So, I know this is absolutely terrible syntax, but the calculation I want is something like '=(PCI Flag = Yes) / ((PCI Flag = Yes) + (PCI Flag = No))'

I know I need to use something more like ( {$<[PCI Flag]={Yes}>} [PCI Flag]) but I am just unsure of the exact syntax that I need.

Any help would be greatly appreciated!

Re: Calculated Expression

prat1507 — Fri, 29 Sep 2017 13:53:28 GMT

Use

Sum({<[PCI Flag]={'Yes'}>} Amt)/(Sum({<[PCI Flag]={'Yes'}>} Amt)+Sum({<[PCI Flag]={'No'}>} Amt))

Sum({<[PCI Flag]={'Yes'}>} Amt)/(Sum(Amt)

Regards

Pratyush

Re: Calculated Expression

krishnacbe — Fri, 29 Sep 2017 13:55:16 GMT

Do you need to provide the % of Yes and not for No

Re: Calculated Expression

krishnacbe — Fri, 29 Sep 2017 13:56:51 GMT

Hope attached sample will help if you need to show the % of both No & Yes

Re: Calculated Expression

shinnickr — Fri, 29 Sep 2017 13:57:31 GMT

Yeah just the % of yes. So in the picture it's Yes = 222; No = 29. What I want to show is 222/(222+29), which would be 88.45%

Re: Calculated Expression

krishnacbe — Fri, 29 Sep 2017 14:10:06 GMT

Then the expressions shared by Pratyush will help you.

Re: Calculated Expression

vinieme12 — Fri, 29 Sep 2017 14:16:29 GMT

Dimension

[PCI Flag]

Expression

=count([PCI Flag]) / count(TOTAL [PCI Flag])

Re: Calculated Expression

shinnickr — Fri, 29 Sep 2017 16:45:36 GMT

Thanks for all the help everyone! I actually got it all figured out.

=num(count({<[PCI Flag] = {'Yes'}>}[Field ID]) / count({<[PCI Flag] = {'Yes', 'No'}>}[Field ID]), '##.##%')