topic % True 90 Day in QlikView

% True 90 Day

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

=Count({$<[Planner Group]={'SVC'},[True 90 Day] = {'Yes'}>} [SO TECO Date])/Count({$<[Planner Group]={'SVC'},[Customer Owned] = {'Yes'}>} [SO TECO Date])

I use the above expression to get the % True 90 day. In the chart, it’s giving the expected result with having the line graph on the chart. However, when I click on the

True 90 Day = ‘Yes’ filter, the chart loses the line graph. The True 90 day has values of (‘Yes’,’No’,’Blank’). I can see the line graph when selecting the ‘Blank’ but loses it when I select either ‘Yes’ or ‘No’.

Can you please help me with the correct expression so that I’ll not lose the line graph even when selecting from the filter. Thank you in advance.

Re: % True 90 Day

swuehl — Thu, 22 Sep 2016 20:42:37 GMT

Maybe clear the selection in this field in your second aggregation:

=Count({$<[Planner Group]={'SVC'},[True 90 Day] = {'Yes'}>} [SO TECO Date])

Count({$<[Planner Group]={'SVC'},[Customer Owned] = {'Yes'}, [True 90 Day]=>} [SO TECO Date])

Re: % True 90 Day

xarapre7 — Thu, 22 Sep 2016 21:25:20 GMT

It worked! Thank you.