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

Announcements
Join us in Bucharest on Sept 18th 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