I’m looking for an aggregate function in Qlik sense to do the below
My data table looks like below.
Part
Plan
Actual
Percentage(Caluclated as Actual/ Plan)
A
3
3
100%
B
3
6
200%
C
4
4
100%
D
5
0
0%
E
0
2
#DIV/0!
F
0
0
#DIV/0!
G
4
3
75%
H
2
0
0%
I
0
3
#DIV/0!
I want the output as a bar graph with the data as shown below
Percentage
Count
0%
2
75%
1
100%
2
200%
1
>100%
2
N/A
1
Please see the colors from the input table and out table for a clear understanding of the data.
Please note that when the plan is 0 and actual is >0, I want the Percentage to show as > 100% with count as number of records (in this case it is 2).
If both plan and actual are 0. I want the Percentage to be N/A or something unique. So, it can be treated as no plan and no actual (In this case we have only 1 record).
