topic Re: Hiding a Column in a pivot in QlikView

Hiding a Column in a pivot

Mon, 11 Aug 2014 06:46:54 GMT

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 ?

simenkg — Mon, 11 Aug 2014 06:52:25 GMT

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

Mon, 11 Aug 2014 07:11:22 GMT

Thanks a lot SKG !

It works..

simenkg — Mon, 11 Aug 2014 07:22:30 GMT

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

Regards
SKG

aveeeeeee7en — Mon, 11 Aug 2014 07:33:03 GMT

Use this:

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

Regards

Aviral Nag