Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bafanaz3672
Contributor II
Contributor II

How to create one chart expression

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post