topic Re: Variable not working in a drill down table in QlikView

Variable not working in a drill down table

helen_pip — Wed, 22 Jan 2014 10:48:49 GMT

Hello

I have a table which is a drill down table. I have a variable which simply is =Count(ID)

When I place the variable in the expression, my table does not return any values

Is it possible to use variables in a drill down table? If so could some kindly let me know what I am doing wrong

sudeepkm — Wed, 22 Jan 2014 10:58:12 GMT

Please try $(v_Count) in your expression.

sudeepkm — Wed, 22 Jan 2014 11:03:26 GMT

if you want to

1. store the count of ID value in a variable then use like below

v_count = count(ID)

else if you want to store the count(ID) text in a variable for reuse purpose then use like below

v_Count = 'count(ID)'

Use $(v_Count) in your chart expression

helen_pip — Wed, 22 Jan 2014 11:16:58 GMT

Hello Sudeep

Thank you for your reply. I have tried your technique and unfortunately I get the same figure for every row.

I.e. in the example above I get the figures 86 for every row in the table

Do you have any further suggestions?

Kind Regards

Helen

Anonymous — Wed, 22 Jan 2014 11:28:51 GMT

Hi Helen,

Take a look at the attachted document.

Is that what you are looking for?

Dennis.

sudeepkm — Wed, 22 Jan 2014 11:34:01 GMT

You can declare your variable like below.

v_Count = 'count(ID)' in the Variable Overview window

helen_pip — Wed, 22 Jan 2014 11:38:50 GMT

Hello Dennis

Thank you ofr your help. This works perfectly. All I need to do was take of the equals sign

Thanks

Helen

helen_pip — Wed, 22 Jan 2014 11:39:58 GMT

Hello Sudeep

I have solved the problem. The outcome was to just take the equals sign off when declaring the variable

Thank you for your help and suggestions

Helen