Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]=
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)
This is likely used in a Set Analysis expression to ignore field selections.
Sum({<$(yourvar)>}Amount)
-Rob