Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
Amberj_29
Contributor III
Contributor III

Calculated dimension with added metric - set analysis?

Hi All, 

I need some help as I have been stuck on this.

I have a table that tells me the customer name, first date of purchase (calculated dimension) and first order value of that purchase. I just cannot get the first order value to match up can anyone help?

first date of purchase is correct:  =date(aggr(Min([Reporting Month.autoCalendar.YearMonth]),Name_business)) 

I've tried several variations of the above for 'first order value' metric and I just can't get it to work including put it into a set analysis. I am going wrong somewhere but I don't know where, any help would be great. 

 

1 Reply
Jayavignesh
Contributor III
Contributor III

WOuld be good if you attach your qvf file.