Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Qlik Table row hide

 

Hello,

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

 

ItemsTotal SalesAsia_SalesEurope_SalesOceania_SalesAction
Apple2101To Hide
Orange6150To Show
Jerry2200To 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! 

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

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!

View solution in original post

2 Replies
Highlighted
Partner
Partner

Hi, 

 

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

 

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

 

Br

Highlighted
Contributor III
Contributor III

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!

View solution in original post