Discussion board where members can learn more about Qlik Sense App Development and Usage.
I’m looking for an aggregate function in Qlik sense to do the below
My data table looks like below.
Percentage(Caluclated as Actual/ Plan)
I want the output as a bar graph with the data as shown below
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).
May be this
If(Plan = 0 and Actual = 0, 'N/A',
If(Plan = 0, '>100%',
If(Actual = 0, '0%',
If(Actual/Plan <= 0.75, '75%',
If(Actual/Plan <= 1, '100%'
If(Actual/Plac <= 2, '200%'))))))