GetFieldSelections() usando valores não selecionados

[#1]

Boa Tarde,

Necessito de uma ajuda. Preciso saber os valores "NÃO" selecionados de um determinado filtro. É possível???

Necessito saber os meses não selecionados para fazer uma análise diferente.

Preciso que a variável retorne "OUT, NOV, DEZ" sem o NOT

Obrigado

[Anonymous]

No worry, Qlik current selection does this..

Any way it wud not harm your data or analysis.

You can set the length of your current selections...

PFA..

[tresesco]

Like:

=Concat(DISTINCT{1<MonthField=E(MonthField)>}MonthField, ',')

So, variable definition becomes like:

vNotSelectedMonths='NOT ' & Concat(DISTINCT{1<MonthField=E(MonthField)>}MonthField, ',')

[#4]

It work's, thank you!!!! Excelent!!!!

There is a away, when i select "only" 1 month, for example "Set", qlikview will retrieve me the months lower than "Set" in one variable vLowerMonths, and in another variable vHigherMonths????

Thanks!!

[#5]

Still have a little problem, it returns "dez, nov, out" how i can use this values to apply another filter???

When i use the variable "vNotSelectedMonths" as a month filter it wont work...

Thank you.

[tresesco]

Say you want sum of sales for those Note Selected/Excluded values. Then use expression like:

Sum({<MonthField= - $:: MonthField>}Sales)

[tresesco]

Or, for variable way, create variable like:

vExcludedValues=Chr(39)&Concat(DISTINCT{1<MonthField=E(MonthField)>}MonthField, chr(39)&','&chr(39))&chr(39)

Then in the expression try like:

Sum({<MonthField={$(vExcludedValues)}>}Sales)

[#8]

Thank you... it is correct now!!!!!

Excelent