Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
its_rajvir
Creator
Creator

Multiple where clause

Hi Expert,

Need your help.

I want to fetch records something like this :

where LocationId = 296 and TxTyp = CI 

Where LocationId = 302 and TxTyp = CO

how can i get this 

Looking for response

Thanks 

Regards

 

Labels (3)
1 Reply
marcus_sommer

Maybe in this way:

where (LocationId = 296 and TxTyp = 'CI') or (LocationId = 302 and TxTyp = 'CO')

- Marcus