topic Re: Where in expression use Set Analysis? in QlikView

Where in expression use Set Analysis?

Fri, 23 May 2014 14:14:53 GMT

Hello... Need your help!!!

Maybe this is a stupid question, but I´ve tried hard, and cannot make this work...

I´m using this expression to give MTD values:

Sum( $(vSetMTD) MyField)

But I need to exclude something from values, so I´m trying to use Set Analysis, like:

{$<Category-={'FieldName'}>}

Where do I insert this Set analysis???

I´ve tried before variable, after variable... and nothing... It just ignores the set analysis!

Thank you all!

Best Regards,

BS.

Re: Where in expression use Set Analysis?

maxgro — Fri, 23 May 2014 14:24:53 GMT

what is?

$(vSetMTD)

Re: Where in expression use Set Analysis?

upendrarajeshir — Fri, 23 May 2014 14:28:04 GMT

Hello BS,

Go through PDF, this may help you.

Thanks & Regards,

Upendra

Re: Where in expression use Set Analysis?

Fri, 23 May 2014 14:29:01 GMT

In fact is a Set Analysis in a variable.

I will try now to replicate the variable and make the exclusion inside the variable expression!

Re: Where in expression use Set Analysis?

Fri, 23 May 2014 14:29:28 GMT

Not sure what your variable is doing, but the set analysis would go inside the expression. Something like as follows.

Sum({$<Category-={'FieldName'}>} $(vSetMTD) MyField)

Re: Where in expression use Set Analysis?

Joseph_Musekura — Fri, 23 May 2014 14:32:29 GMT

Try

Sum ({<Field1-={‘A’}>}Sales)

will sum all Sales except from field1 : 'A'.

Re: Where in expression use Set Analysis?

Fri, 23 May 2014 14:32:46 GMT

Thanks...

Already had it, but thanks anyway!

Re: Where in expression use Set Analysis?

Fri, 23 May 2014 14:36:11 GMT

Thank you all for trying to help.

Like I´ve said it above, vSetMTD is a variable that allows me Month to Date Analysis! The expression in this variable is in fact a Set Analysis. So what I did was to replicate it, and exclude what I need there, so my expression remains the same.

Sum( $(vSetMTD) MyField)

Thanks!

Problem Solved!