topic Re: Help with syntx conversion in QlikView

Help with syntx conversion

helen_pip — Thu, 12 Nov 2015 12:41:20 GMT

Hello

I know what I would like to achieve in Qlikview, but require some assiatcne with a conversion to qlikview syntax

It is a between statement and the syntex that I would require help with is:

If(Today()-1 between admission_date and Today()-1, 1)

Anyone able to help

Kind Regards

Helen

Re: Help with syntx conversion

sunny_talwar — Thu, 12 Nov 2015 12:43:19 GMT

Not sure I understand what you mean by this -> Today()-1 between admission_date

Can you may be share a few lines of sample with the expected output?

Re: Help with syntx conversion

Peter_Cammaert — Thu, 12 Nov 2015 12:44:18 GMT

This is a weird requirement, as your test value is at the same time the outer boundary of your range. This makes the IF always result in true(). So your code boils down to:

IF (true(), 1)...

Re: Help with syntx conversion

swuehl — Thu, 12 Nov 2015 12:44:29 GMT

If yesterday is between admission and yesterday?

Isn't that always true (or false, depending on how you look at the borders of your between range)?

Re: Help with syntx conversion

Kushal_Chawda — Thu, 12 Nov 2015 12:44:37 GMT

this?

if( admission_date <= today()-1,1)

Re: Help with syntx conversion

Anonymous — Thu, 12 Nov 2015 12:47:40 GMT

You can try this, it wud give you same:

If(Today()-1 >= admission_date, 1)

Re: Help with syntx conversion

buzzy996 — Thu, 12 Nov 2015 13:44:17 GMT

hey,u have to explain a bit more ur expected out ..that helps qlickers to respond quickly.