topic Re: how to exlude filter on expression in QlikView

how to exlude filter on expression

Thu, 04 Oct 2012 12:37:50 GMT

Hi guys, i've a littl bit problem(i hope)

I've got one expression and i need to exclude every filters i've in my project,but i've to mantain only one of them

i know i can use expression looks like sum( total <Filter1,Filter2,...,...,...FilterN> Sales ) by exluding the filter i don't need.

but i've a lot of filter to in my project and it should be better i can specify only this one to be used on my formula.

In substance i'n searching for an expression like this, but that it works on the contrary....

thx a lot.

bye.

Gysbert_Wassenaar — Thu, 04 Oct 2012 12:41:40 GMT

you can use a subset expression; sum( {1} Sales) will disregard selections and calculate the sum over your dimensions.

Thu, 04 Oct 2012 13:15:05 GMT

thx, bu ti need to disregard all selections exept only one.....

Gysbert_Wassenaar — Thu, 04 Oct 2012 13:26:28 GMT

sum({$<Field1= , Field2= }>} Sales) will disregard selections for Field1 and Field2. You can add all the fields that need to be disregarded.

Thu, 04 Oct 2012 13:34:10 GMT

ok, but i've a lot of field to add, meanwhile i want to make the contrary, add the only one filter to be considered

MayilVahanan — Thu, 04 Oct 2012 13:42:02 GMT

Try like this

=sum({1<FieldToKeep=P(FieldToKeep)>}Sales)

Hope that helps

Gysbert_Wassenaar — Thu, 04 Oct 2012 13:51:11 GMT

Maybe something like sum({1<Field1=P()>} Sales). If I understand it correctly this would disregard all selections except the selections for Field1

Thu, 04 Oct 2012 13:58:31 GMT

tried, but not works fine....it consider other selections too, seem to be not works 1 value to have totals...