Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am struggling to add different measures into one Pivot table. Right now my pivot table looks like this:
I have a pivot table which shows me the net hours each division has worked and the %-Difference to the year before.
Under the pivot table i have multiple KPIs. These show me the total amount of hours worked over all, absent hours. And the %-difference from 2016 to 2015 (comparing to the year before).
This doesn't look nice and I supposed to put this all into one table. My problem is if i add a new measure into the pivot table I get them as columns instead of a row below the actual pivot table.
Imagine that I want to enhance the pivot table multiple rows down and include the values that are below the pivot table into the pivot table.
I don't know if that is possible since there is text next to the KPIs. Is it possible to write text into the rows of a pivot table on the right of it the measure?
I thought about creating multiple pivot tables for each line of text and KPIs. But therefor I need to get rid of the headers. I know it's possible in QlikView but I read this function does not exist in QlikSense.
I think I have to make changes during the script. But I don't know what and how I should do that.
I have added a datasample.
Thank you for your help 
Hi Petter,
it comes quite close. The issue why it all should be in one Pivot table is, so that the user is able to break everything down into months. If you look at the top of the Pivot table you see the years 2015 and 2016 with the + next to it. If you press it the pivot table breaks down into months and all the values for each month are shown. So first the user sees the years but when he presses on the + then he sees all the months and their specific values to the Function_Groups.
That's the main reason why it should all into one Pivot table.
Is something like this possible?
But first let me thank you. In my opinion your solution looks already better what I had
Well now that I understand you a bit more clearly ...
Actually it is quite easy to just add the measures into you pivot and along with the measures you have to add the necessary dimensions for grouping an summation and it will look like this:
You can just add additional measures just like I have made the [Amount Hours Net] and [Amount Hours Absent]...
There is just the issue with how the pivot table looks like when I ass the measures.
It should look like this
It's quite close to the solution you posted. Is something like this possible?
Creating two tables that are rather similar is an option that is straight-forward:
If you want to have them in a single pivot table that would be more time consuming to achieve and possibly a "hack" to achieve - nevertheless possible...
Hmm I also thought about building two tables. But the problem is the header of the second table.
I should built them all into one.... that's also my problem.
What sort of "hack" does it need? I can also wait if you might have some time later on.
I really don't know how to do this since all I had was the first introduction training into QlikSense....
Can't thank you enough Petter