Pivot Problem

[#1]

Hi Folks

I have a simple pivot table like this:

but what I'd like to see is this:

I.E: I'd like to only show the EX1 and EX2 expression values at the total level, at the detail level I only want to show EX3 values.

Is this possible, and if so, how?

The data for the above is just using the QlikView test script.

[tresesco]

you might give a try with dimensionality() function.

[agigliotti]

Hello,

I have your same needs.

Did you find any solution to achieve it ?

Currently I'm using SecondaryDimensionality() = 0 condition to populate the expression values only in total column, but I still have the empty columns at detail level !

Please let me know.

Many Thanks & Best Regards

Andrea

[#4]

Hi Andrea

I have a partial solution to this and thankfully a solution that my end user will accept, even though it's not ideal.

For the above example of my data, I have added the expression values EX1, EX2 and EX3 as DIMENSIONS and have used the Aggr Function to ensure that the values shown are correct against the other dimensions I'm showing.

I then pivot over an expression on EX3, and it works fine.

However......

One point you need to be clear on before going down this route is that you now cannot get a Total value for EX1, EX2, EX3 because they are now defined as dimensions, so this is the limitation that my end-user has accepted.

Hope that's fairly clear for you.

[agigliotti]

Hi Nigel,

Thanks for your collaboration but unfortunately I need the total value for the expression.

Well, I'm going to explain to my customer why EX1 showed even in detail level as blank value.

Currently I'm using version 11.20 SR2, I'll try also with the latest version SR3.

Best Regards

Andrea