Discussion board where members can learn more about Qlik Sense App Development and Usage.
Is there an easy way to filter on calculated fields?
Country, Sales, marginNetherlands, 1000, 10%UK, 1200, 15%
Now I want answer questions like 'Show me all lines with a margin higher than 12%' or 'Show me all lines with Sales between 900 and 1500'.
The Sales and margin are calculated fields, like SUM(Sales).With Excel for example I can set a filter on a column header and then filter the lines based on the numbers in that column.
You could use Expression Search, check this link: https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Selections/SelectionsTo...
Hope this helps,
Thanks for the link, but this is not exactly what I'm looking for. The search on '=SUM(Sales)>700' on the country dimensions only works when you have one dimension I think. Suppose you have a second dimension State in this example:
Country, State, Sales, marginNetherlands, A, 800, 10%Netherlands, B, 200, 10%UK, C, 1200, 15%
How can you filter all lines with Sales > 700 (so it displays line 1 and 3)?