topic Lock filter in QlikView

Lock filter

Wed, 11 Apr 2012 11:34:17 GMT

Hello

I want to know how to block a single filter for a specific graphic (because there are several graphics).

In my case, I have "year" filter, my formula detects the most recent two years with the month in common to compare the turnover etc! until then it's perfect except that I would block the selection of the "year" filter to not select another year and to only use the other filters as country etc...!

thank you in advance

Stephane

Lock filter

Wed, 11 Apr 2012 12:25:07 GMT

for information:

My request for help:

for example:

-"Year" filter :2009/2010/2011

-"Country" filter: France/German/USA/INDIA...

- Quantity

- Price

=sum({$<Years ={$(=Max(Years))}>} Quantity*Price) = 10000€ (turn over for all country) represente 2011

=sum({$<Years ={$(=Min(Years))}>} Quantity*Price)= 9000€ (turn over for all country) represente 2009

After that if i choose other year my result change but i don't want that, i want my result change only if i choose "country" filter. but for my "year" filter i want to be always 2011 and 2009 but i can't specifie directly the year in my set analysis because over the time i can have other year!

Do you have any suggestion for me to resolve this problem?

Tks

Lock filter

Anonymous — Wed, 11 Apr 2012 12:47:20 GMT

Try like this

=sum({$< Year=,

Month=,

Years ={$(=Max(Years))}>}Quantity*Price)

Modified the field which i mentioned in bold and use your filter field in that place except the Country and try it

Hope it will helpful

Regards

Ashok

Lock filter

Wed, 11 Apr 2012 13:18:57 GMT

Thank you for answered,

but your answer give me the same things that me.

my formula:

=sum({$<Years ={$(=Max(Years))}>} Quantity*Price) represente 2011 turn over

but if i choose year filter 2010 i would have turn over 2010

concretly the answer what i want:

=sum({$<Years ={2011}>} Quantity*Price)

with this formula even if i choose in year filter 2010 i would have turn over 2011

The probleme is that i don't want specifie{$<Years ={2011}>} because in the futur i will have more year and i will always take the MAX year

Here is my problem!!

Tks

Stéphane Vinoth pelerin

Lock filter

CELAMBARASAN — Wed, 11 Apr 2012 13:24:37 GMT

Hi,

Change this expressions

=sum({$<Years ={$(=Max(Years))}>} Quantity*Price) = 10000€ (turn over for all country) represente 2011

=sum({$<Years ={$(=Min(Years))}>} Quantity*Price)= 9000€ (turn over for all country) represente 2009

=sum({$<Years ={$(=Max({1} Years))}>} Quantity*Price)

=sum({$<Years ={$(=Min({1} Years))}>} Quantity*Price)

Celambarasan

Lock filter

CELAMBARASAN — Wed, 11 Apr 2012 13:25:54 GMT

Hi,

You can also use

Max(ALL Years) and Min(ALL Years) because both are same.

Celambarasan

Lock filter

Wed, 11 Apr 2012 13:31:15 GMT

Tks Celambarasan,

you are great!!!