Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a table similar to this:
What I need to calculate is the Total No of Units - 32 and the Month where the the first units were sold - Mar 13. I need to create a chart that will look as follows:
I have Site as a Dimesion. The calculation for units sold is, this works fine:
However I am sturggling to work out the Calculated Dimension to give me the Month where Units <> 0 and Month = Min(Month) where a value exists?
Any help appreciated.
Go to Solution.
See attached example.
Thank You Gysbert!