Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis with Variable

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]



1 Reply
sunny_talwar

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])