Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hiding a Column in a pivot


Hi,

I have two Dimensions - (a) DimA, and (b) DimB across which I want to show SUM(c).....DimA has 4 possible values - a1,a2,a3 and a4.

In my pivot table, I dont want to display SUM(c) for value a1 of DimA.

Does anybody has any idea about it ?

1 Solution

Accepted Solutions
simenkg
Specialist
Specialist

you use the expression Sum({$<DimA-={'a1'}>}c)


It will give you a syntax error (Red underline) but will work non the less.


If you prefer to not get syntax errors you can use:

sum({$<DimA={'a2','a3','a4'}>}c)


Regards

SKG

View solution in original post

4 Replies
simenkg
Specialist
Specialist

you use the expression Sum({$<DimA-={'a1'}>}c)


It will give you a syntax error (Red underline) but will work non the less.


If you prefer to not get syntax errors you can use:

sum({$<DimA={'a2','a3','a4'}>}c)


Regards

SKG

View solution in original post

Not applicable
Author

Thanks a lot SKG !

It works..

simenkg
Specialist
Specialist

Glad I could help. Remember to mark the correct answer as such to help others with the same problem.

Regards
SKG

aveeeeeee7en
Specialist III
Specialist III

Use this:

=Sum({<DimA={'*'}-{a1}>}c)

Regards

Aviral Nag