topic Re: Hiding Rows based on selection in QlikView

Hiding Rows based on selection

Anonymous — Tue, 12 Jan 2016 08:05:53 GMT

Hi All

I have a requirement where I should hide rows from a straight table based on selection.

The values which are selected is Hide Row filter must be hidden from the table.

For example I have selected Coconut oil and Niacinamide. Both the values must be hidden from the table. But I am not able to hide. Only when a single selection is made in HideRow filter the row is hidden.

There are two dimensions Commodity Number and groupName which has alias name 'Ingredients'

The filter 'Hide Row' denotes groupName. groupName is given a alias name as 'Hide Row'.

The expression which i have used is

=SUM({<groupName={'*'}-{"$(vSelectedGroups)"},INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity)

where

vSelectedGroups = GetFieldSelections(groupName,',',20)

Can anyone help me on this.

Thanks

Koushik

Re: Hiding Rows based on selection

tamilarasu — Tue, 12 Jan 2016 08:18:40 GMT

Try expression as,

If(Getselectedcount(groupName)=0, SUM({<groupName={'*'}-{"$(vSelectedGroups)"},INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity), SUM({1-$<groupName={'*'}-{"$(vSelectedGroups)"},INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity)

Re: Hiding Rows based on selection

PrashantSangle — Tue, 12 Jan 2016 08:34:34 GMT

Hi,

Try e() in set analysis,

try like

=SUM({<groupName=e(groupName),INGREDIENT_TYPE={'SUB-INGREDIENT'}>}quantity)

Regards,