topic Auto Hide rowns based on condition in QlikView

Auto Hide rowns based on condition

raju_salmon — Tue, 18 Oct 2016 01:05:39 GMT

Hi,

I have a straight table with many dimensions and expression.

There is expression called Sum(Responses), if this values is zero, then i need to hide entire row irrespective of other expression values? I have tried many ways but no use.

Can anyone help me what to do?

Re: Auto Hide rowns based on condition

Tue, 18 Oct 2016 01:10:11 GMT

Go to Properties-> settings for selected Dimension -> tick on checkbox Suppress when value is null

It may work for you

Re: Auto Hide rowns based on condition

sunny_talwar — Tue, 18 Oct 2016 01:22:08 GMT

You can use an if statement for all your expressions to force them to be null when Sum(Responses) = 0. So something like this

If(Sum(Responses) > 0, Expression1)

If(Sum(Responses) > 0, Expression2)

...

and so on...

Re: Auto Hide rowns based on condition

lawrance — Tue, 18 Oct 2016 02:01:31 GMT

RE: Auto Hide Rows based on the condition

Hi Raju,

Please try this below condition.

You can use set analysis for that conditional statement.

For Example,

=SUM({Responses ={'> 0'}>} Expression}

Thanks,

Lawrance A

Re: Auto Hide rowns based on condition

raju_salmon — Tue, 18 Oct 2016 04:14:21 GMT

Thanks Sunny, do i need to keep condition for all expressions to exclude whole row? or can we set any condition for dimension?

Re: Auto Hide rowns based on condition

sunny_talwar — Tue, 18 Oct 2016 09:36:45 GMT

You can do this for your dimension also....

Aggr(If(Sum(Responses) > 0, YourDimensionName, ListAllDimensionsHere)

Few things:

1) You just need to do this for one dimension

2) List all the dimensions within the Aggr function

3) Remember to check 'Suppress When Value Is Null' on the dimension tab.

Re: Auto Hide rowns based on condition

raju_salmon — Tue, 18 Oct 2016 11:58:39 GMT

Thanks Sunny, i will implement and mark it as correct response.

Re: Auto Hide rowns based on condition

raju_salmon — Wed, 19 Oct 2016 05:10:39 GMT

Hi Sunny,

I have followed the below steps and not working. Can you please see where i have gone wrong.

I have two dimensions

Date_Group (Drill down group)

DayName

Already dayname has one condition where it display only when date is selected.

Now i have kept a condition for Date_Group condition as below

Aggr(If(Sum(Responses) > 0, Date_Group, DayName)

and i checked 'Suppress When Value Is Null'.

In above response you have mentioned below

Aggr(If(Sum(Responses) > 0, YourDimensionName, ListAllDimensionsHere)

In above statement May i know what is "YourDimensionName"? and ListAllDimensionsHere?

Thanks Sunny.

Re: Auto Hide rowns based on condition

raju_salmon — Wed, 19 Oct 2016 05:18:06 GMT

Got it Sunny, i have taken calculated dimension.