topic Re: Using a variable in set analysis in QlikView

Using a variable in set analysis

Anonymous — Wed, 28 Feb 2018 19:56:55 GMT

I have this expression:

=SUM({$<[CleanMonth]={'2017/01'}, [ProdType]={'129'}>} Net_Revenue_Value)

This works perfectly. When I try to add in a variable in its place, I return no results.

SUM({$<[CleanMonth]={$(vNextSalesPeriod)}, [ProdType]={'129'}>} Net_Revenue_Value)

vNextSalesPeriod is a value from a database table which returns 2017/01 and shows correctly when I reference it in a text box. Do I need to wrap it in something else to get it to read in the variable?

Thank you.

Re: Using a variable in set analysis

sunny_talwar — Wed, 28 Feb 2018 20:09:30 GMT

May be one of these

Sum({$<[CleanMonth]={'$(vNextSalesPeriod)'}, [ProdType]={'129'}>} Net_Revenue_Value)

Sum({$<[CleanMonth]={'$(=vNextSalesPeriod)'}, [ProdType]={'129'}>} Net_Revenue_Value)

Sum({$<[CleanMonth]={'$(=$(vNextSalesPeriod))'}, [ProdType]={'129'}>} Net_Revenue_Value)

Re: Using a variable in set analysis

shilpan — Wed, 28 Feb 2018 20:42:27 GMT

Agreed with Sunny; add single quotes around dollar-sign expansion for the month field