Filter the data from expressions

[#1]

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.

Customer Country	OPM Upper	OPM Lower
	No	No
Albania	Yes	No
Algeria	No	Yes
Andorra	No	No
Angola	Yes	No
Etc	Etc----	Etc---

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

--->A-man

[qlikviewwizard]

Hi,

Please attach the sample application.

[marcus_sommer]

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