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!