Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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)...
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)?
this?
if( admission_date <= today()-1,1)
You can try this, it wud give you same:
If(Today()-1 >= admission_date, 1)
hey,u have to explain a bit more ur expected out ..that helps qlickers to respond quickly.