topic Re: Set Analysis, Multiple Expressions in QlikView

Set Analysis, Multiple Expressions

EvanBarrick — Wed, 12 Dec 2018 16:33:30 GMT

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?

Re: Set Analysis, Multiple Expressions

marcus_malinow — Wed, 12 Dec 2018 16:52:44 GMT

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])

Re: Set Analysis, Multiple Expressions

marcus_malinow — Wed, 12 Dec 2018 16:57:11 GMT

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])

Re: Set Analysis, Multiple Expressions

albert_guito — Wed, 12 Dec 2018 18:12:42 GMT

Try with

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

Ag+

Re: Set Analysis, Multiple Expressions

albert_guito — Wed, 12 Dec 2018 18:23:40 GMT

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