topic Re: How to create one chart expression in QlikView

How to create one chart expression

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

Hi there,

PFA,

Could you please assist me with creation of one chart expression. I would like to have a situation like this

Issue_Rule Score

<20% issues are AIV 5

<79% Limited issues 12

>16% overdue less than 6 months 13

>21% Major issues 14

and so forth.

I am hoping if I can be assisted with the above, I will be able to calculate the percentages and create charts and not use text boxes.

Thanks

Re: How to create one chart expression

Gysbert_Wassenaar — Sat, 17 Nov 2018 07:33:52 GMT

Actually I won't combine the expressions into one, but simply add another expression to the table that sums the other four and then hide the others. See attached example.

If you do want one expression then you just need to expand your pick function and add the parts that are now in the four expressions you have. Not that hard, just tedious.