topic Re: Hide a value of a dimension in QlikView

Hide a value of a dimension

Fri, 10 Oct 2014 15:09:32 GMT

Hi guys,

I would to know if it's possible to hide a specific value of a dimension in a pivot table.

Assuming that I have a dimension FlagStatus which has 2 values : debtors and creditors.

I want to hide the debtors value in the display but the total of the dimension gives me the total of both value. Is it possible to do so ?

Re: Hide a value of a dimension

Peter_Cammaert — Fri, 10 Oct 2014 15:17:31 GMT

So the total expression should be something else than the expression for dimension values immediately above? Seems difficult for end-users to interprete...

Re: Hide a value of a dimension

antoniotiman — Fri, 10 Oct 2014 15:24:43 GMT

Hi Patrick,

In Color Text of expression

If(Dimensionality() > 0,

If(FlagStatus='debtors',ARGB(0,0,0,0)))

Regards

Re: Hide a value of a dimension

Fri, 10 Oct 2014 15:30:26 GMT

Re: Hide a value of a dimension

Fri, 10 Oct 2014 15:31:02 GMT

I hope the image above could explain more

Re: Hide a value of a dimension

antoniotiman — Fri, 10 Oct 2014 15:37:36 GMT

I don't see your Dimensions

In Text Color :

If(Dimensionality() >0,

If(Dim1='Value1' and Dim2='Value2',ARGB(0,0,0,0)))

Re: Hide a value of a dimension

antoniotiman — Fri, 10 Oct 2014 15:46:47 GMT

Or in case of Dimension, the same in text color of Dimension.

Re: Re: Hide a value of a dimension

antoniotiman — Fri, 10 Oct 2014 16:19:36 GMT

I have tried to replicate your example.

See attachment

Re: Hide a value of a dimension

Fri, 10 Oct 2014 16:28:49 GMT

Thanks for your reply. but this is not exactly what I want.

Re: Hide a value of a dimension

Fri, 10 Oct 2014 16:30:10 GMT