topic Re: Show All values sorted and grouped in dimension In Pivot Table in QlikView

Show All values sorted and grouped in dimension In Pivot Table

Klaus — Mon, 01 Mar 2021 13:08:34 GMT

My pivot table has five dimensions and one expressions.

And here is how it looks.

How can I display in the existing selection to see this?
I don't know how to exploit the dimension 'Nr.bon' to reach the excel result.

Re: Show All values sorted and grouped in dimension In Pivot Table

edwin — Mon, 01 Mar 2021 13:18:33 GMT

is the requirement not to show that field yet preserve the distribution of the expression even when multiple dimension rows are the same? since this is an aggregation, any duplicate combination of dimensions will be collapsed into one row.

Re: Show All values sorted and grouped in dimension In Pivot Table

Klaus — Mon, 01 Mar 2021 13:31:47 GMT

I accept any suggestion that approaches the excel model, I don't necessarily want to keep all the dimensions

Re: Show All values sorted and grouped in dimension In Pivot Table

edwin — Mon, 01 Mar 2021 13:50:21 GMT

one of the differences between a straight table and pivot is that in a straight table you have the ability to hide columns. so you can still use the Nr.bon as a dimension and just hide it. you will see the individual expression values as if Nr.bon were still shown. obviously, your year and week will be in separate rows not columns.

if however, the year and week columns (in pivot) were finite, you can simulate these two (for example) columns as separate expressions where using variables (as one solution) your first expression would have something like
{<[Calendar Year]={$(vPriorYear)}, [CalendarWeekOfYear]={$(vWeek)}>}
2nd expression:
{<[Calendar Year]={$(vCurrentYear)}, [CalendarWeekOfYear]={$(vWeek)}>}

this mimics the pivot table having two columns
=$(vPriorYear) &'
' & $(vWeek)
to look like
2020
2

maybe that helps

Re: Show All values sorted and grouped in dimension In Pivot Table

Klaus — Tue, 02 Mar 2021 06:33:16 GMT

The method given by you is the most suitable. Thank you for your help!

Re: Show All values sorted and grouped in dimension In Pivot Table

edwin — Wed, 03 Mar 2021 19:37:00 GMT