Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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
Partner
Partner

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
Partner
Partner

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
Partner
Partner

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