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: 
Mgx
Contributor
Contributor

Have Measure and M-1 Measure in a table with Date as Dimension

Hello, 

I am looking for a table that gives me the sum of sales and in another column the sum of M-1 sales. I have a result with rangesum and above, but if I select a Date it's no more working. 

Dimension : Date

1st Measure : sum(Sales)

2nd Measure : I try Sum({<[Date.autoCalendar.Date]={"=$(vMONTH)"}, Date=>}Sales) with vMONTH :addmonths(Date, -1) / sum({<Date={"=Date(Date-30, 'M/D/YYYY')"}>}Sales)--> Not working, 

Exemple : 

10 juin 2022  / Sales : 100 

10 juillet 2022 / Sales 145 / SalesM-1 : 100

Thanks for your help ! 

Labels (1)
1 Reply
Dalton_Ruer
Support
Support

Use the chart function ABOVE. Above(Sum(Sales))

AboveSales.png