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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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