Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kuhbrille
Contributor III
Contributor III

merge or group data in pivot

Hi,

in a pivot table we need to do a sum based on week and week_os, but we only want to see the 'merged' result.

Like using a grouping in the calcualtion for week and week_os, but only showing the week.

Here is an example I made in Excel.

Maybe someone can understand, what I am looking for and maybe there is a solution for that.

Kind Regards

Roland

example.png

Message was edited by: Roland Walde

12 Replies
Anil_Babu_Samineni

May be change it to Straight Table?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

Seems like you don't really need Week_OS dimension... have you tried removing it to see if you get what you want?

kuhbrille
Contributor III
Contributor III
Author

this is a simple example... we need the pivot table for totals, changing dimensions by the user... and some more reasons

kuhbrille
Contributor III
Contributor III
Author

without the Week_OS the docind2 calculation would be wrong on aggregated level

sunny_talwar

Would you be able to share a sample?

kuhbrille
Contributor III
Contributor III
Author

example uploaded

sunny_talwar

Check out the attached

Capture.PNG

kuhbrille
Contributor III
Contributor III
Author

thx, that looks good, there is one more thing which makes it more complicated... the dimensions and measures are conditional, the user can decide via button click which to be shown... will check that out, if it also works... moment

kuhbrille
Contributor III
Contributor III
Author

and one more: if you collapse dim3, the docind2 should not just aggregated... first it must aggregate the other measures and then calculate on that result, based on week and week_os....