Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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!
Hi,
You can do this in your measure - something along the lines of:
Sum({<Items={"=Sum(TotalSales)>amountlimit"}>}sum TotalSales)
Br
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!