topic Multiple filters in single expression in QlikView

Multiple filters in single expression

vikas_nandanwar — Wed, 20 Dec 2017 10:30:57 GMT

Hi,

How to use multiple filters in single expression?

I need following expression

Sum(Qty)

Exclude

Year = 2017 and

PType = Sal

My below expression is not working

Sum({<Ptype={"Sal"}>,<[Year]={"2017"}>} Qty)

Please suggest

Thanks,

Vikas

Anil_Babu_Samineni — Wed, 20 Dec 2017 10:35:53 GMT

Exclude should be -=

Sum({<Ptype-={"Sal"}>,<[Year]-={2017}>} Qty)

vikas_nandanwar — Wed, 20 Dec 2017 10:39:47 GMT

Not Working

Sum({<Ptype-={"Sal"}>,<[TransactionDate.autoCalendar.Year]-={2017}>} Qty)

My expression

Anil_Babu_Samineni — Wed, 20 Dec 2017 10:42:04 GMT

You are not suppose to do with 2 angular bracket like, Though try this?

Sum({<Ptype-={"Sal"},[TransactionDate.autoCalendar.Year]-={2017}>} Qty)

OR, If you want to do using OR operator do this

Sum({<Ptype-={"Sal"}>+<[TransactionDate.autoCalendar.Year]-={2017}>} Qty)

vikas_nandanwar — Wed, 20 Dec 2017 10:45:02 GMT

Thanks this worked

Anil_Babu_Samineni — Wed, 20 Dec 2017 13:23:26 GMT

Great, Please close this thread

Théo123 — Thu, 23 Nov 2023 14:36:37 GMT

Bonjour,

SI <+> correspond à OR, à quoi correspond le ET ?

Cordialement

theoat — Tue, 13 Feb 2024 13:53:26 GMT

Bonjour,

<+> correspond à une union (OR), alors que <*> correspond à une intersection (ET).

Cordialement,
Théo ATRAGIE.