topic Re: Evaluating a variable on straight table in QlikView

Evaluating a variable on straight table

nkosinde13 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I have a variable that I created and I'm using it on a straight table as part of an expression, but it's not returning any value.

IF(SaleType1 = 'Total SBIB Sales Penetration',$(vTotal)

How do I evaluate a variable in an if statement? Please assist.

Thank you

Re: Evaluating a variable on straight table

neelamsaroha157 — Tue, 21 Aug 2018 13:25:15 GMT

May be you can use $1 in your variable expression and then pass the value of SalesType1 -

For Example -

vTotal = Sum(Sales) then you can replace it by Sum({<$1>}Sales) or Sum({<SaleType1 = {$1}>}Sales)

And then the expression (If using second expression)- $(vTotal('Total SBIB Sales Penetration'))

Re: Evaluating a variable on straight table

manoj217 — Tue, 21 Aug 2018 13:44:57 GMT

IF(SaleType1 = 'Total SBIB Sales Penetration',$(vTotal)

you missed the ) at last and check your sales type1 value it is matched or not with your existing data

Re: Evaluating a variable on straight table

nkosinde13 — Wed, 22 Aug 2018 09:03:17 GMT

Hi Neelam. Thank you but I'm not understanding the example you gave me. Are you saying I should create a variable for Total SBIB Sales Penetration then call the variable in the expression? I'm being confused by $1 part in your comment. Can you please elaborate further. Thanks

Re: Evaluating a variable on straight table

nkosinde13 — Wed, 22 Aug 2018 09:04:53 GMT

Hi Manoj, It's still not working. Thanks

Re: Evaluating a variable on straight table

shiveshsingh — Wed, 22 Aug 2018 09:38:52 GMT

Try this

IF(SaleType1 = 'Total SBIB Sales Penetration',"$(=vTotal)")

IF(SaleType1 = 'Total SBIB Sales Penetration','$(=vTotal)')

Re: Evaluating a variable on straight table

manoj217 — Wed, 22 Aug 2018 09:41:32 GMT

can you share the variable definition

Re: Evaluating a variable on straight table

neelamsaroha157 — Wed, 22 Aug 2018 12:50:16 GMT

Check this resource for parameters in set analysis -

$-Sign Expansions in QlikView

So the $1 is like defining the parameters where you can supply the values later while using the variable.

Re: Evaluating a variable on straight table

nkosinde13 — Tue, 28 Aug 2018 12:33:34 GMT

Thank you very much Neelam, this is really helpful.

Re: Evaluating a variable on straight table

nkosinde13 — Tue, 28 Aug 2018 12:35:16 GMT

Thank you guys, but nothing is working. So in the meantime I created same variable twice, one with an = mark and the other without as I'm using them on different objects.