Discussion board where members can get started with QlikView.
I am trying to build a bar chart counting the number of orders at each stage in the process, these stages are numerical.
My problem is that each order can have multiple stages within it, and I want to report on the earliest (smallest number) of those stages.
For example, I want to be able to have the minimum task stage as depicted below as a dimension in a bar chart.
I've tried using min(total<[Order Reference]>[Stage])
But that displays an Invalid Dimension error.
is there a solution to this?
Go to Solution.
In your chart, try as calculated dimension
aggr(min(TOTAL <Order> Minimum_Task_Stage),Order,Stage)
May be you need this
Aggr(Min(Stage), [Order Reference])
Thank you for this - I don't get an error anymore, but it is returning all values as null.
What all dimensions do you have in your chart? Do you have any expressions?
thank you both so much for your help.
The expression which worked was:
aggr(min(TOTAL <[Order Reference]> [Stage]),[Order Reference],[Stage])