Set syntax not working when having two sets in the expression

Thu, 16 Apr 2015 00:33:55 GMT

Hi,
I have a real hard time getting the set expression working. These two expressions works perfectly:

SUM({<[key_Week] = {">=$(vP1Start) <=$(=vP1End)"}>} [BB_Net_USD])

Sum({$<Currency_ISO_CD=>} {$<Unit_type=>} {$<Filter_Product=>}[BB_Net_USD])

But when I try to do this

Sum({$<Currency_ISO_CD=>} {$<Unit_type=>} {$<Filter_Product=>}

{<[key_Week] = {">=$(vP1Start) <=$(=vP1End)"}>} [BB_Net_USD])

The first section is ignored, the result is the same than the first formula I show. I would expect the number to be much higher.

I have been trying different things for hours and asked a couple colleagues to no avail. Is it possible to do this?

Thanks, Philippe

Re: Set syntax not working when having two sets in the expression

Oleg_Troyansky — Thu, 16 Apr 2015 01:05:08 GMT

Philippe,

only the first of all of your expressions can work properly. The rest are incorrect.

Each aggregation function, such as sum(), can only have one Set Analysis expression. Within this single expression, you may use multiple Set Identifiers, if they are used with set operators. Each Set ID uses a single set of Modifiers, enclosed in angled brackets. Multiple modifiers are separated by commas. So, your second expression should look like this:

Sum({$<Currency_ISO_CD=, Unit_type=, Filter_Product= >}[BB_Net_USD])

Your third expression should be formulated like this:

Sum({$<Currency_ISO_CD=, Unit_type=, Filter_Product=, [key_Week] = {">=$(vP1Start) <=$(=vP1End)"}>} [BB_Net_USD])

cheers,

Oleg Troyansky

Come and learn Set Analysis with me at the Masters Summit for QlikView - www.masterssummit.com

topic Set syntax not working when having two sets in the expression in QlikView

Set syntax not working when having two sets in the expression

Re: Set syntax not working when having two sets in the expression