Pivot Table Alternatives?

[gregoryk]

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?

[chris_djih]

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.