topic Re: how to hide a value in a pivot table in QlikView

how to hide a value in a pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

In my report I want a value against itemnumber ie 50,76,56,4,62,248 should be hidden or removed from table.

pLease help!!!!

report screenshot is attached below

Wed, 30 Aug 2017 10:51:32 GMT

you can use not equal to operator for this

dineshm030 — Wed, 30 Aug 2017 10:56:41 GMT

Hi Saksham,

There is no HIDE option in pivot table. Instead of Pivot table you can use Straight Table. It has a HIDE option for the field.

Regards,

Dinesh Kumar.

Anil_Babu_Samineni — Wed, 30 Aug 2017 10:56:52 GMT

May be expression like below

Sum({<ItemNumber -= {'50','76','56','4','62','248'}>} Measure)

Anonymous — Thu, 31 Aug 2017 04:43:06 GMT

i have used rangesum() function as rangesum(north,south,east,west,tbc) but not please tell me how to apply not equal to operator ?

Anil_Babu_Samineni — Thu, 31 Aug 2017 04:53:42 GMT

Why not this?

Only({<ItemNumber -= {'50','76','56','4','62','248'}>} rangesum(north,south,east,west,tbc))

Anonymous — Thu, 31 Aug 2017 05:51:18 GMT

thanks...it was useful for me

Anil_Babu_Samineni — Fri, 01 Sep 2017 06:17:21 GMT

Please close this thread by flag Helpful and Correct Answer to close this thread

Note - Please free to ask if issue still not resolved.