Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
mkalan
Contributor
Contributor

Qlikview - Variable Value with Commas and Field Values

I have a variable in QlikView with Field names separated with commas and equal signs. What does this mean?

Variable Value

 [Contract Remaining Term In Months]=, [Contract Number]=, [Contract Status]=, [Contract Type]=, [Contract Region]=, [Contract Company Code]=, [Contract Sales Rep]=, [Contract Term In Months]=, [Contract Description]=,[Contract Group]=, [Contract Billing Interval]=

 

 

 

2 Replies
jwjackso
Specialist III
Specialist III

The variable is probably being used in Set Analysis to force those fields to ignore filters

Sum({<$(Variable Value)>} Amount)

When I've done this, I added a comma at the beginning of the variable and placed the variable at the end of the Set Analysis statement.

Sum({<Year={'201'}$(Variable Value)>}Amount)

This way when the $(Variable Value) is expanded, it looks like

Sum({<Year={'2021'},[Contract Remaining Term in Months]=...[Contract Billing Interval]=>}Amount)

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

This is likely used in a Set Analysis expression to ignore field selections. 

Sum({<$(yourvar)>}Amount)

-Rob