topic Re: Straight table show only dimension with values - hide in QlikView

Straight table show only dimension with values - hide

Mon, 09 Sep 2013 13:09:08 GMT

Hello,

I have this chart

How can i make it so it only shows my members where there is a number all the way?

So those with zeros, should not be shown, it should be like this:

5213731 602,00, 1, 2

only!

Re: Straight table show only dimension with values - hide

tresB — Mon, 09 Sep 2013 13:16:46 GMT

Is your second column a dimension? If so you can check 'Suppress When Value is Null' for that dimension, else for all the expressions, you have to put conditional appearance(presentation tab).

Re: Straight table show only dimension with values - hide

swuehl — Mon, 09 Sep 2013 13:17:26 GMT

You can try to zero columns 2 and 3 where column 1 is not a number:

for your second expression:

=if(isnum(Column(1), ExpressionColumn2)

for your third expression:

=if(isnum(Column(1), ExpressionColumn3)

Then check 'Suppress zero values' on presentation tab.

Re: Straight table show only dimension with values - hide

Mon, 09 Sep 2013 13:22:15 GMT

Column, 2,3,4 are expressions.

Only column one is a dimension.

I did this for column 3

If(column2 >=1, sum(column3), null())

same expressions is here

=if(Sum({<Date_Clean={'$(vDynamicDateUser)'}>} AntalBuy) >=1,Sum({<Date_Clean={'$(vDynamicDateUser)'}, EventTypeKey={196}>}AntalBesøg),null())

would this work proper?

Re: Straight table show only dimension with values - hide

Clever_Anjos — Mon, 09 Sep 2013 13:23:17 GMT

Both @tresesco and @swuehl

Re: Straight table show only dimension with values - hide

tresB — Mon, 09 Sep 2013 13:43:33 GMT

Try this:

calculated dimension : Aggr(If(Sum({<Date_Clean={'$(vDynamicDateUser)'}>} AntalBuy)>0,YourDimension) ,YourDimension)

Then check 'Suprress When Value is Null' in the dimention tab.

Re: Straight table show only dimension with values - hide

pranubitla — Fri, 18 Nov 2016 17:37:03 GMT

Dear Experts,

I have a question, please help. similar to the above example I have 6 dimensions in the list, I would like to hide only null values, from the 6 dimensions see the below screenshot only last 5 rows , if dimension A has a null value, Dimension B with a value, that should show. can you suggest me something