First Sold date as Dimension

[#1]

Hi

Within Qlikview 9 I have set up a table as follows:

			Periods	F2011 P01	F2011 P02	F2011 P03	F2011 P04
Product	Category	Descritpion
1	Beef	Steak		101	204	307	410
2	Poultry	Chicken thighs		202	180	158	136
3	Pork	Pork Loin		50	65	80	95

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.

Thanks, Gareth

Status: New to Qlikview 😉

[syed_muzammil]

Hi,

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,

F2,

Date

From XYZ;

left join

Load F1,

F2,

min or max(Date)

From XYZ group by F1,F2;

This way you will get the last date for the particular category.

Regards,

Syed

[johnw · Accepted solution]

Maybe this as a calculated dimension?

aggr(min({1}invoicedate),Product)

Probably best to do what Syed says and build it while you load, though. The chart will display faster that way.

[#4]

Thanks, that worked a treat.

(Unfortunately didn't try the table option not yet there 😉