topic Re: Hide a field in a dimension in QlikView

Hide a field in a dimension

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

Hi Guys,

I have a chart below and I want to hide one of the fields in the dimension, any ideas, I know you can do it on a table but how on a chart?

Re: Hide a field in a dimension

andrey_krylov — Mon, 01 Oct 2018 13:39:40 GMT

Maybe editing expression

=if( not ThisField like 'Currently atten*', ... )

or set analysis {< ThisField -= {'Currently atten*'} >}

Re: Hide a field in a dimension

vitaliichupryna — Mon, 01 Oct 2018 13:43:40 GMT

Hi,

You can use set analysis. For example:
sum({<Category -= {"Currently"}>}Sales)
This expression will show sum of sales for all categories except of "Currently"

Thanks,
Vitalii

Re: Hide a field in a dimension

sweens78 — Mon, 01 Oct 2018 14:28:13 GMT

Hi Andrey should it be the a edited Dimension I nned to add rather than expression?

I tried the first code but getting errors?=if( not ThisField like 'Currently atten*', ... )

Re: Hide a field in a dimension

raman_rastogi — Mon, 01 Oct 2018 14:38:18 GMT

Try this

Calculated dimension

if (dim='value',' ',dim)

and Suppress null values for dimension.

Regards

Raman

Re: Hide a field in a dimension

rajivmeher — Mon, 01 Oct 2018 14:46:27 GMT

Hi Martin

Have you tried puting the following condition in dimension?

IF(Field_Name <> 'Currently atten'(please mention the full value here), Field_Name)

You can go into dimension tab, select the dimension and edit it. Add the above expression and see if the dimension value gets hidden in the chart?

Regards

Rajiv.

Re: Hide a field in a dimension

andrey_krylov — Mon, 01 Oct 2018 16:04:00 GMT

This can be both an expression and a dimension, as suggested by Raman and Rajiv. You need to determine what field is used in the chart and put it in the formula.

1. Dimension: = if ( field <> 'Currently atten...', field )

'Currently atten...' - this value must be completed. And Suppress null values

2. Expression: to the used expression add this condition, for example

sum( if ( field <> 'Currently atten...', Amount ) )

or in set analysis sum( {< field -= {'Currently atten...'} >} Amount )