Discussion board where members can get started with Qlik Sense.
I have below scenario to display Qlik Table data basis Action input.
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!
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 QVDleft 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
View solution in original post
You can do this in your measure - something along the lines of: