Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible to add an expression for certain columns of a pivot table?

I have a pivot table where I pivoted one dimension. The secondary dimensionality of the aggregate is 0, the secondary dimensionality of the subtypes is 2. I now want to add two expressions that are only calculated and shown for the aggregate. I am, however, at a complete loss about how to get there.

If I add an if-condition like if(SecondaryDimensonality()=0, sum(Flag)) the expression is also added to the subtypes, only it's empty there. Is there a possibility to achieve what I want to? I'm using QV10 SR3.

3 Replies
chematos
Specialist II
Specialist II

See this discussion:

http://community.qlik.com/message/46308#46308

hope this helps

Not applicable
Author

Hei. Thanks for pointing me there. I had already read this one, however.
I also know, that I can have different expressions in different columns according to their dimensionality.
My problem is, that I want to add an expression only to a certain column (it splits the column into two) and keep the other columns as they are.
(I tried to add a picture that might be able to explain better what I try to achieve, however the upload here is not functioning at the moment.)

IAMDV
Luminary Alumni
Luminary Alumni

Hi,

Please can you upload sample QV file? I understand that you can't upload picture but can you give another try?

Thanks,

DV