Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

First Sold date as Dimension

Hi

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

PeriodsF2011 P01F2011 P02F2011 P03F2011 P04
ProductCategoryDescritpion
1BeefSteak101204307410
2PoultryChicken thighs202180158136
3PorkPork Loin50658095


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 ;-)

1 Solution

Accepted Solutions
MVP
MVP

First Sold date as Dimension

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.

3 Replies
syed_muzammil
Contributor II

First Sold date as Dimension

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

MVP
MVP

First Sold date as Dimension

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.

Not applicable

First Sold date as Dimension

Thanks, that worked a treat.

(Unfortunately didn't try the table option not yet there ;-)

Community Browser