Pivot Table Alternatives?

gregoryk — Tue, 22 Feb 2022 13:57:03 GMT

Hi - I've been tasked with trying to recreate this excel spreadsheet (image below) in QlikSense.

I can easily create the first block as a pivot table (which is data at daily level), but can't figure out how to add the other columns (weekly and monthly values), without having another pivot table next to it (with the row headers repeating).

Any ideas?

Re: Pivot Table Alternatives?

chris_djih — Wed, 23 Feb 2022 08:34:41 GMT

You can try to use Pick().
1. Create a helper Dimension as data island

DIM: Load * Inline [View Daily Weekly Monthly];

2. choose "View" as column dimension
3. Use Pick() in your measures

=Pick(Match(View, 'Daily','Weekly','Monthly'), If(Dimensionality()=0,Date, <Your Daily measure1> ), If(Dimensionality()=0,Date(Weekend(Today())), <your Weekly Measure 1> ), If(Dimensionality()=0,Date(Monthend(Today())), <your Monthly Measure 1> ) )

with Dimensionality()=0 you can define a different formular for the sub totals (your second headings).

Repeat this for every Measure. This methods only works, if in each View you provide the same amount of Measures.

topic Pivot Table Alternatives? in App Development

Pivot Table Alternatives?

Re: Pivot Table Alternatives?