topic Re: Hide values from displaying in a table? in QlikView

Hide values from displaying in a table?

Wed, 24 Sep 2014 18:48:20 GMT

Hi all -

I have a table displaying data from a number of fields. There is are a few values in one of the fields that I would like to hide. I don't want to get rid of them as they are used in other areas of the app, but for this particular table it would be great to hide them. Is there a way to do this? Thanks!

Re: Hide values from displaying in a table?

vgutkovsky — Wed, 24 Sep 2014 18:53:13 GMT

Sure, you can do this with set analysis in the expressions. For example: sum({<Product-={'Shoes','Hats'}>} Sales). This will cause Shoes and Hats to not be displayed as dimensions. QlikView will underline this syntax is red, but it is correct. If the syntax check bothers you, here's an alternative: sum({<Product=E({<Product={'Shoes','Hats'}>}Product)>} Sales)

Regards,

Vlad

Re: Hide values from displaying in a table?

maxgro — Wed, 24 Sep 2014 18:57:28 GMT

maybe setting null() the values you want hide

if(match(expression, ..., ..., .....), null(), expression)

if(RowNo(Total)>10 and RowNo(Total)<13, null(), RowNo(Total))

Re: Hide values from displaying in a table?

vgutkovsky — Wed, 24 Sep 2014 18:59:10 GMT

Massimo, calculated dimensions should typically be avoided unless absolutely necessary, as they tend to have a detrimental effect on application performance. If something can be accomplished with set analysis, that's preferable.

Vlad

Re: Hide values from displaying in a table?

Wed, 24 Sep 2014 19:09:30 GMT

Vlad, this looks to have worked! Thank you! One question though - I have six expressions (Total, FY14, FY15, FY16, FY17, FY18) and I only applied the set analysis modified to Total, which seems to have hidden the offending lines. Is there any reason I should apply the modifier to FY14-FY18 as well?

Re: Hide values from displaying in a table?

vgutkovsky — Wed, 24 Sep 2014 19:20:35 GMT

Technically you only need to apply it to the "offending" expressions (the ones that would cause a non-zero and non-null value to be returned). Depending on how many values you're excluding, you may achieve a small performance improvement by applying this to all expressions.

Vlad

Re: Hide values from displaying in a table?

Wed, 24 Sep 2014 19:27:21 GMT

Got it. Thank you Vlad!