Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
EvanBarrick
Creator
Creator

Multiple Conditions in an Expression

I want to format an expression to function when the following conditions are met

 

dimension = transDATE

first expression: =SUM({$<promoCDE={"Adult*"},}>}[Net Sold Qty])

second expression / condition = nwEVENTDTE = '11/21/2018'

 

How would I format this?

 

1 Solution

Accepted Solutions
Thiago_Justen_

I'm not sure if I understood your request but here it is:

 

Sum({$<promoCDE={"Adult*"},nwEVENTDTE={"$(=Today())"}}>}[Net Sold Qty])

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago

View solution in original post

1 Reply
Thiago_Justen_

I'm not sure if I understood your request but here it is:

 

Sum({$<promoCDE={"Adult*"},nwEVENTDTE={"$(=Today())"}}>}[Net Sold Qty])

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago