topic Re: Condition syntax in QlikView

Condition syntax

Mon, 21 Sep 2015 16:25:15 GMT

Hi,

Please tell me what's wrong with the below syntax:

= '=TEST_CASE_STATUS=' & chr(39) & 'Complete-Passed' & chr(39) & 'AND TEST_EXPIRATION_DT1=' & TIMESTAMP(TODAY())

It's not working.

Thanks,

Sudha.

Re: Condition syntax

maxgro — Mon, 21 Sep 2015 16:36:08 GMT

add in a textbox and see what it happens

maybe you need comma before and after the timestamp

Re: Condition syntax

Mon, 21 Sep 2015 16:39:14 GMT

I have to do this in button and it's not working. Comma before and after timestamp doesn't help.

Re: Condition syntax

Digvijay_Singh — Mon, 21 Sep 2015 16:49:02 GMT

Check if fieled being checked is having multiple values, else share sample data and output for better understanding.

Re: Condition syntax

Mon, 21 Sep 2015 17:32:25 GMT

Hi,

Here is the screen shot. As you can see Test-533 and Test-534 has today's expiration date and have the Status as 'Testing Evidence' but the button condition does not work.

Thanks,

Sudha.

Re: Condition syntax

Mon, 21 Sep 2015 20:07:00 GMT

Hi,

Any update on this question? Please assist.

Thanks,

Sudha.

Re: Condition syntax

sasiparupudi1 — Mon, 21 Sep 2015 20:20:43 GMT

Please check if the format of your date time field matches to the expression timestamp(Today())

hth

Sasi

Re: Condition syntax

Mon, 21 Sep 2015 20:36:15 GMT

How to make sure they both are in the same format? When I directly give the date field and mention timestamp(today()) in search string, it is working fine. However when I give TEST_CASE_ID and put the whole expression in search string as shown below, it is breaking. But, I have one more condition to add, so I need this one to work.

Please help.

Re: Condition syntax

jonas_rezende — Mon, 21 Sep 2015 20:52:41 GMT

Hi, sudha viswanathan.

Try to test separately the button and see what the outcome. Ex.: First button 1; second button 2.

I hope this helps!

Re: Condition syntax

Mon, 21 Sep 2015 20:55:51 GMT

Hi,

Both are working fine individually. But when added together in a single search string, it does not work. Especially the timestamp condition is not working as I had shown in the screen shot.

Thanks,

Sudha.

Re: Condition syntax

MarcoWedel — Mon, 21 Sep 2015 22:39:01 GMT

Hi,

did you try the solutions proposed to you in this thread Filter Conditionfor the very same question?

regards

Marco