topic Re: Create a new Expression or Variable in QlikView

Create a new Expression or Variable

Thu, 25 Apr 2013 16:04:27 GMT

I'm having a hard time trying to find or figure out how to create a new expression or variable that helps me solve this issue.

I have a field "Purchased" that has no value or count of products purchased like 1,2,4,7,....

I want to create a new variable or expression to basically tell if Purchase is True or False. False if no value and True if >=1

Tried stuff in the script, creating expression in the list box...all to no avail and I'm stuck.

Any help is appreciated.

derekjones — Thu, 25 Apr 2013 16:27:27 GMT

Hi Vijay

try using len function in an expression e.g.

=if(len(Purchased)>0,'TRUE','FALSE')

Hope this helps

Derek

Thu, 25 Apr 2013 19:03:45 GMT

Great thanks. That worked!

I was doing double quotes around True and False and it did not like that.