Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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])