Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Month Calculated Dimension

Hi,

I have a table similar to this:

SiteMonthYear Units
East LintonJan130
East LintonFeb130
East LintonMar1317
East LintonApr

13

15

What I need to calculate is the Total No of Units - 32 and the  Month where the the first units were sold - Mar 13. I need to create a chart that will look as follows:

SiteMonth of PurchaseUnits Sold
East LintonMar 1332

I have Site as a Dimesion. The calculation for units sold is, this works fine:

sum(Aggr(DISTINCT $(vUnitsSold),Site))

However I am sturggling to work out the Calculated Dimension to give me the Month where Units <> 0 and Month = Min(Month) where a value exists?

Any help appreciated.

Thanks,

Nikki

1 Solution

Accepted Solutions

Re: Month Calculated Dimension

See attached example.


talk is cheap, supply exceeds demand
2 Replies

Re: Month Calculated Dimension

See attached example.


talk is cheap, supply exceeds demand
Not applicable

Re: Month Calculated Dimension

It Works!

Thank You Gysbert!

Community Browser