Discussion Board for collaboration related to Creating Analytics for QlikView.
I'm getting a mental block on this, it seems quite a simple problem but I can't get my head around it!
I have monthly totals for a number of years:
I would like to display a table that contains
Month Min(Value) Year
So that I have a list of months from January to December, with the lowest Value for that month and the year in which that monthly value was e.g.
Month Min Value Year
Jan 12 2000
Feb 8 1987
Mar 15 2010
Apr 65 1993
Dec 32 1972
I've tried various combinations of dimensions and expressions, but not getting very far. Any ideas/pointers in the right direction would be appreciated.
Go to Solution.
Try Month as dimension and two expressions:
Hope this helps,
Thanks for the quick reply! Ended up having to use FirstSortedValue(distinct yr, val) and that worked a treat.