topic Re: How to filter on calculated fields in App Development

How to filter on calculated fields

heij1421 — Tue, 02 Jul 2019 08:55:43 GMT

Hi,

Is there an easy way to filter on calculated fields?

Example:

Country, Sales, margin
Netherlands, 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.

Re: How to filter on calculated fields

jaygarcia — Tue, 02 Jul 2019 13:07:59 GMT

Hello Heij421,

You could use Expression Search, check this link: https://help.qlik.com/en-US/sense/April2019/Subsystems/Hub/Content/Sense_Hub/Selections/SelectionsToolbar/search-selections.htm

Hope this helps,

Jay

Re: How to filter on calculated fields

heij1421 — Tue, 02 Jul 2019 13:36:40 GMT

Hi Jay,

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, margin
Netherlands, 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)?

Re: How to filter on calculated fields

jaygarcia — Tue, 02 Jul 2019 14:20:49 GMT

Hi
I see. One way could be to create a filter pane with an expression like this:
=aggr(sum(Sales),Channel,State)
and then you can search >700 in the filter pane.
regards,
Jay