Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where in expression use Set Analysis?

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.

1 Solution

Accepted Solutions
Not applicable
Author

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!

View solution in original post

7 Replies
maxgro
MVP
MVP

what is?    

$(vSetMTD)

upendrarajeshir
Contributor II
Contributor II

Hello BS,

Go through PDF, this may help you.

Thanks & Regards,

Upendra

Not applicable
Author

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!

Not applicable
Author

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)

Joseph_Musekura
Support
Support

Try

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

 

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

Not applicable
Author

Thanks...

Already had it, but thanks anyway!

Not applicable
Author

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!

View solution in original post