Discussion board where members can get started with Qlik Sense.
I'm trying to create a cumulative aggregation between dates.
I have an order table with ORDER_NUMBER, ORDERED_DATE, INVOICE_DATE, INCOME
The end result needs to be a Bar Chart that presents the income of the orders that the Quarter of the invoice greater from the ordered date
see the example below
Please find my solution by join your data to a calendar table as shown below
and then create a measure expression as below
Hope this helps
Thanks, but the original table contains more than 80 columns, and I'm trying to avoid using IF statements.
Is there a way to do that with Aggr and RangeSum with Set Analysis?