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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
EvanBarrick
Creator
Creator

Set Analysis, Multiple Expressions

I am attempting to get the sales for the past seven days for a particular type of buyer. 

Expressions 1: 

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

 

Expression 2:

=SUM({<[Transaction Date]={">=$(=Date(max([Transaction Date])-7,'MM-DD-YYYY'))"}[Net Sold Qty]

 

When I combine, I get an error. Do I have the structure incorrect for either expression?

1 Solution

Accepted Solutions
albert_guito
Creator II
Creator II

Try with

=SUM({<promoCDE={'Adult'},[Transaction Date]={">=$(=Date(max([Transaction Date])-7,'MM-DD-YYYY'))"}>} [Net Sold Qty]

Ag+
Ag+

View solution in original post

4 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

Have you tried out either of these expressions? I'm seeing syntax errors in both.

 

SUM({$<promoCDE={'Adult'}>}[Net Sold Qty])

SUM({$<[Transaction Date]={">=$(=Date(max([Transaction Date])-7))"}>} [Net Sold Qty])

Combined

SUM({$<promoCDE={'Adult'}, [Transaction Date]={">=$(=Date(max([Transaction Date])-7))"}>}[Net Sold Qty])

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Have you tried out these expressions individually? I'm seeing slight syntax issues with both.

Would suggest the following:

SUM({$<promoCDE={'Adult'}>}[Net Sold Qty])

SUM({<[Transaction Date]={">=$(=Date(max([Transaction Date])-7))"}>} [Net Sold Qty])

and combined:

SUM({$<promoCDE={'Adult'}, [Transaction Date]={">=$(=Date(max([Transaction Date])-7))"}>} [Net Sold Qty])

 

albert_guito
Creator II
Creator II

Try with

=SUM({<promoCDE={'Adult'},[Transaction Date]={">=$(=Date(max([Transaction Date])-7,'MM-DD-YYYY'))"}>} [Net Sold Qty]

Ag+
Ag+
albert_guito
Creator II
Creator II

If you want to use separate the first has a comma and curly bracket at the end of modifier and the second needs to close the modifier with semicolom and other curly bracket
Ag+