Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

% True 90 Day

=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.

2 Replies

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])

Creator II
Creator II

It worked!  Thank you.