Set Analysis with Variable

Wed, 10 Jun 2015 16:42:44 GMT

Can I replace the following with variable (such as "filterValues") and resuse in other expressions:

[LOB]=$::[LOB],[Risk State]=$::[Risk State],[Claim Symbol Group]=$::[Claim Symbol Group],
[Claim Symbol SubCode]=$::[Claim Symbol SubCode],[Source]=$::[Source],
[Policy Form Name]=$::[Policy Form Name],[Writing Company]=$::[Writing Company],
[Claim Office Description]=$::[Claim Office Description],[Region]=$::[Region]>

Entire expression:

sum({1<[Calendar Year]={$(vSelectedYear)},[Calendar Month]={"<=$(=vSelectedMonth)"},

[LOB]=$::[LOB],[Risk State]=$::[Risk State],[Claim Symbol Group]=$::[Claim Symbol Group],
[Claim Symbol SubCode]=$::[Claim Symbol SubCode],[Source]=$::[Source],
[Policy Form Name]=$::[Policy Form Name],[Writing Company]=$::[Writing Company],
[Claim Office Description]=$::[Claim Office Description],[Region]=$::[Region]>

} [Claims Reported])

Re: Set Analysis with Variable

sunny_talwar — Wed, 10 Jun 2015 17:17:33 GMT

Have you tried this (I am not 100% certain that it will work, but worth giving it a shot)

vVar = '[LOB]=$::[LOB],[Risk State]=$::[Risk State],[Claim Symbol Group]=$::[Claim Symbol Group],
[Claim Symbol SubCode]=$::[Claim Symbol SubCode],[Source]=$::[Source],
[Policy Form Name]=$::[Policy Form Name],[Writing Company]=$::[Writing Company],
[Claim Office Description]=$::[Claim Office Description],[Region]=$::[Region]'

Save the variable with the single quotes, but without = sign.

and then use it like this:

=Sum({1<[Calendar Year]={$(vSelectedYear)},[Calendar Month]={"<=$(=vSelectedMonth)"}, $(vVar)>} [Claims Reported])

topic Set Analysis with Variable in QlikView

Set Analysis with Variable

Re: Set Analysis with Variable