Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand
Not applicable
Author

It Works!

Thank You Gysbert!