topic Comparing string variables in QlikView

Comparing string variables

kim_rormark — Mon, 08 Aug 2011 12:07:31 GMT

Hi,

I am trying to do an "if.. then" on two string variables, but it won't do it for me. Do I have to use something else to do this?

Ex.:

if Peek('Type', $(i), 'Incidents') = "Downtime" then
   ....
endif

Here Peek('Type', $(i), 'Incidents') will return the correct value that I want to compare with "Downtime". In the log-file it shows that the correct values are compared.

Ex. if Downtime = "Downtime" then

I also tried removing and adding quotes in every possible way, and I also tried using the text() function.

Help?

Re: Comparing string variables

lironbaram — Mon, 08 Aug 2011 12:27:23 GMT

hei

attach is an example

i tried what you wrote

it seems to work

checkout to any diffrences

Comparing string variables

kim_rormark — Mon, 08 Aug 2011 12:34:29 GMT

Of course, single quotes. I though i tried that but obviously not.

Thank you so much!