topic Re: Qlikview - Variable Value with Commas and Field Values in QlikView

Qlikview - Variable Value with Commas and Field Values

mkalan — Thu, 13 May 2021 16:17:28 GMT

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]=

Re: Qlikview - Variable Value with Commas and Field Values

jwjackso — Thu, 13 May 2021 19:26:09 GMT

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)

Re: Qlikview - Variable Value with Commas and Field Values

rwunderlich — Thu, 13 May 2021 19:55:55 GMT

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

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

-Rob