topic Re: How to Hide 2 Same Column Values? in QlikView

How to Hide 2 Same Column Values?

Fri, 12 Jun 2015 14:34:55 GMT

Hi All,

How do i hide Values that are the same on Column A and on Column B

Thanks

alexandros17 — Fri, 12 Jun 2015 14:35:41 GMT

Col A and B are dimensions or expressions?

Fri, 12 Jun 2015 14:37:46 GMT

Hi,

They are Dimensions.

Thanks

rajeshvaswani77 — Fri, 12 Jun 2015 14:38:38 GMT

Hi,

If you put in a Pivot table, they will get grouped as one.

thanks,

Rajesh Vaswani

Fri, 12 Jun 2015 14:42:50 GMT

Hi,

The client need it in Straight Table.

Thanks.

maxgro — Fri, 12 Jun 2015 18:03:41 GMT

maybe

add a calculated dimension for field f1 and field f2

=if(f1=f2, null(),'')

suppress when null

hide this dimension in presentation tab

Mon, 15 Jun 2015 06:17:41 GMT

Hi Massimo,

Thanks alot i used your code and it work Fine the way i want.

Thanks.

maxgro — Mon, 15 Jun 2015 08:24:21 GMT

if you get the answer please close the discussion giving correct and/or helpful

Mon, 15 Jun 2015 08:28:14 GMT

Hi All,

Massimo Managed to Help me with the Script.

Thanks Guys