Discussion board where members can get started with QlikView.
Within Qlikview 9 I have set up a table as follows:
I need to add, as a dimension, the first sold date (Field name "InvoiceDate") regardlessof the active selections.
The closest I have got is an expression by using min(invoicedate), however this splits it by the periods.
Any help/suggestions would be appreciated.
Status: New to Qlikview ;-)
Go to Solution.
Maybe this as a calculated dimension?
Probably best to do what Syed says and build it while you load, though. The chart will display faster that way.
You can create an extra feild while Loading the table for the first sold date and use that field in the dimension.
Eg: Load F1,
min or max(Date)
From XYZ group by F1,F2;
This way you will get the last date for the particular category.
Thanks, that worked a treat.
(Unfortunately didn't try the table option not yet there ;-)