topic Re: Filter the data from expressions in QlikView

Filter the data from expressions

Fri, 28 Aug 2015 15:21:55 GMT

Hey Guys,

I have a data set where I have to sort the data ascending and descending as per the filtered option.

Here is an example of what I need to do:

Data set -

1. Countries, Profit margins

2. Range of profit margins

First filter - Take upper or lower profit margins

Second filter - ascending or descending

I have created a chart and list box with the if statements : =if((sum(ALLOCATION1_EBIT)/sum([LC-NET_REV]))>=Upper, 'Yes', 'No')

(sum(ALLOCATION1_EBIT)/sum([LC-NET_REV]) = Profit margins

I get something like this.

Now I need to filter with OPM Upper or Lower. Can someone please help?

--->A-man

qlikviewwizard — Sat, 29 Aug 2015 02:32:56 GMT

Hi,

Please attach the sample application.

marcus_sommer — Sat, 29 Aug 2015 10:21:12 GMT

I think you will need aggr() to create such filter:

Listbox-expression with and without if-loop:

if(aggr(sum(ALLOCATION1_EBIT)/sum([LC-NET_REV]), [Customer Country])>=Upper, 'Yes', 'No')

aggr(round(sum(ALLOCATION1_EBIT)/sum([LC-NET_REV]), 0.01), [Customer Country])

Maybe an alternatively is to cluster the results with class - within the listbox or in the chart:

class(aggr(sum(ALLOCATION1_EBIT)/sum([LC-NET_REV]), [Customer Country]), 0.01)

- Marcus