topic Set Expression with variable as set modifier in QlikView

Set Expression with variable as set modifier

gerrycastellino — Thu, 19 Nov 2015 00:32:06 GMT

vMac_Rating count( {< [Mac Rating]={'$(vRating_List)'} >} [Mac Rating])

vRating_List

0,1,2,3,4,5,6,7,8,9,10

How do I format my variable to be read into the set expression.

I have these as lines in an Excel file.

Gerry.

sunny_talwar — Thu, 19 Nov 2015 00:45:37 GMT

Try it without the single quotes:

Count({<[Mac Rating] = {$(vRating_List)}>} [Mac Rating])

tamilarasu — Thu, 19 Nov 2015 01:10:01 GMT

Hi Gerry,

Another solution,

count( {< [Mac Rating]={$(=vRating_List)} >} [Mac Rating])

gerrycastellino — Thu, 19 Nov 2015 01:14:24 GMT

You are the greatest !