Discussion board where members can get started with Qlik Sense.
I want to create a pivot table exactly as below. I have channel name ,Purchase value, month,year in DB. How I can create last 3 months purchase in column value?
Perhaps with an expression like
And perhaps not. It depends on what kind of data values your month field contains. Strings like 'Jul' and 'Aug' won't work in the above expression.