Qlik Table row hide

[mkb_Qlik]

Hello,

I have below scenario to display Qlik Table data basis Action input.

Items	Total Sales	Asia_Sales	Europe_Sales	Oceania_Sales	Action
Apple	2	1	0	1	To Hide
Orange	6	1	5	0	To Show
Jerry	2	2	0	0	To Show

To explain above table,

When count of sales in any one of this region (Asia_Sales ,Europe_Sales, Oceania_Sales) 1 or 0 only then i have to hide that row.

When any one of this region count >1 then i have to show the row data.

In this case apple to be hided and rest of two to be displayed.

Help me to fix this!

Thanks in advance! 

[mkb_Qlik]

Hello,

I have below scenario to display Qlik Table data basis Action input.

Items	Total Sales	Asia_Sales	Europe_Sales	Oceania_Sales	Action
Apple	2	1	0	1	To Hide
Orange	6	1	5	0	To Show
Jerry	2	2	0	0	To Show

To explain above table,

When count of sales in any one of this region (Asia_Sales ,Europe_Sales, Oceania_Sales) 1 or 0 only then i have to hide that row.

When any one of this region count >1 then i have to show the row data.

In this case apple to be hided and rest of two to be displayed.

Help me to fix this!

Thanks in advance! 

[hornstrup]

Hi, 

You can do this in your measure - something along the lines of:

Sum({<Items={"=Sum(TotalSales)>amountlimit"}>}sum TotalSales)

Br

[mkb_Qlik · Accepted solution]

Hello All,

I have fixed this by following below steps,

1. Region wise count taken and stored in separate table

2. Created flag with below script for region wise 

Load upper(ITEMS) as ITEMS,Asia_Sales,If((Asia_Sales>1 or Asia_Sales=1) or (Oceania_Sales>1) or (Europe_Sales>1 ),'Y','N') as Asia_Sales_FG from QVD

left join (MASter)

Load upper(ITEMS) as ITEMS,Europe_Sales,If((Europe_Sales>1 or Europe_Sales=1) or (Oceania_Sales>1) or ( Asia_Sales>1 ) ,'Y','N') as Europe_Sales_FG from QVD
left join (MASter)

Load upper(ITEMS) as ITEMS,Oceania_Sales,If((Oceania_Sales>1 or Oceania_Sales=1) or (Europe_Sales>1) or ( Asia_Sales>1 ),'Y','N') as Europe_Sales_FG from QVD

3. I have used this flag in my dimension and hided the required value

thanks!