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: 
Hauglaen
Contributor II
Contributor II

Create trends from different dates

Hi,

I have the following sales data:

DateSales product ASales product BSales product C
jan.20100  
feb.205090 
mar.206060110
apr.20786030
mai.20605030
jun.20  50

 

I want to create a first, second, third ect. sales month.
Rather than compare jan.20 with feb.20.

How can i creat a table like this:

MonthTotal sales
1300
2140
3150
4178
560

 

Thanks!

0 Replies