Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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