Combining rows into columns in qliksense pivot table

Aspiring_Developer — Wed, 24 Aug 2022 10:45:01 GMT

Hello All,

I have below table :-

Dimension - Category | Subdimension

1) Measure for DYOY - (Sum({<[Sub Dimension]= {'Direct Online'},Date=,Year=,MonthYear=, test={">=$(=Num(MonthStart(Max(test)))) <=$(=Num(Max(test)))"}>}Volume)
/
Sum({<[Sub Dimension]= {'Direct Online'},Date=,Year=,MonthYear=,
test={">=$(=num(monthstart(addmonths(max(test),-12)))) <=$(=num((monthend(addmonths(max(test),-12)))))"}>}Volume)) -1

Using above logic , created other 2 measure by changing values in set analysis.

My requirement is that I need to show this table in below format :-

I have attached my data file as well in this post .

Can anyone please help me ?

@hic

Re: Combining rows into columns in qliksense pivot table

Mark_Little — Mon, 05 Sep 2022 06:13:21 GMT

HI @Aspiring_Developer

What is the issue you are facing? You should be able to just add the required dimensions to the table, just be aware your set analysis will limit you sub dimension you see to the one defined in the set expression

topic Combining rows into columns in qliksense pivot table in App Development

Combining rows into columns in qliksense pivot table

Re: Combining rows into columns in qliksense pivot table