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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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]=

 

 

 

Labels (1)
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