topic First Sold date as Dimension in QlikView

First Sold date as Dimension

Mon, 04 Oct 2010 11:28:27 GMT

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.

Thanks, Gareth

Status: New to Qlikview 😉

syed_muzammil — Mon, 04 Oct 2010 14:47:34 GMT

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 — Mon, 04 Oct 2010 22:50:52 GMT

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.

Wed, 06 Oct 2010 08:57:15 GMT

Thanks, that worked a treat.

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