Evaluating a variable on straight table

[nkosinde13]

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

[neelamsaroha157]

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'))

[manoj217]

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

[nkosinde13]

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

[nkosinde13]

Hi Manoj, It's still not working. Thanks

[shiveshsingh]

Try this

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

or

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

[manoj217]

can you share the variable definition

[neelamsaroha157]

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.

[nkosinde13]

Thank you very much Neelam, this is really helpful.

[nkosinde13]

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.