topic Re: Doubt with set analysis in QlikView

Doubt with set analysis

Thu, 26 Feb 2015 14:11:06 GMT

Hi everybody

i have this function

SUM({<Date= {'$(#vMAxFecha)'}>}Money)

It's working OK

Now i have to ignore selections in "Q"

How i ignore selections in a field? I tried - and {1} but it's not working.

Regards

robert_mika — Thu, 26 Feb 2015 14:13:52 GMT

try

SUM({1<Date= {'$(#vMAxFecha)'}>}Money)

alex_millan — Thu, 26 Feb 2015 14:15:46 GMT

Perhaps,

SUM({<Date= {'$(#vMAxFecha)'}, [FieldName]=>}Money)

Regards,

Thu, 26 Feb 2015 14:15:50 GMT

Hi Jeremias,

if you just want to ignore the selection of that single field name use

SUM({<Q=,Date= {'$(#vMAxFecha)'}>}Money)

if you want to ignore all other selections use the 1 solution Robert provided

hope that helps

Joe

Thu, 26 Feb 2015 14:17:55 GMT

Hi Jeremias

Using {1} will ignore selections in all fields.

If it just selections in "Q" you want to ignore, then try the following

SUM({<Date={'$(#vMAxFecha)'},Q=>}Money)