topic Expression in variables not working in QlikView

Expression in variables not working

vikas_nandanwar — Thu, 17 Jan 2019 06:24:54 GMT

Hi,

I am creating a variable name - IssueToFinalLT
Definition -
=IF(([Final Date]-[Issue Date])<3,'< 3 Days',
IF(([Final Date]-[Issue Date])<5,'3 to < 5 Days',
IF(([Final Date]-[Issue Date])<8,'5 to < 8 Days',
IF(([Final Date]-[Issue Date])<15,'8 to < 15 Days','> 15 Days'))))

All my data is getting grouped under '> 15 Days', and i am not getting the error.

Please help
- Vikas

Re: Expression in variables not working

laujerry — Thu, 17 Jan 2019 07:27:45 GMT

i think we cant tell anything without your data

we do not know whether the expression is reflecting the truth or it shows sth wrong (not as you expected)

Re: Expression in variables not working

vikas_nandanwar — Thu, 17 Jan 2019 07:49:39 GMT

Hi there,
I am attaching data excel for your reference.

Re: Expression in variables not working

jonathandienst — Thu, 17 Jan 2019 08:39:30 GMT

Your expression looks OK if used within a suitably dimensioned table. Have you tested replacing the variable with the actual expression? Are they both valid numeric date values?

If either of the dates is null for that row, the expression will return >15 Days.

Re: Expression in variables not working

vikas_nandanwar — Thu, 17 Jan 2019 08:56:51 GMT

Yes the date are valid dates and returns a numeric value if calculated individually.

but when used in variable, it returns with >15 Days only
pleas find attached data file for the same

Re: Expression in variables not working

laujerry — Wed, 23 Jan 2019 02:13:18 GMT

try removing the equal sign at the beginning of your variable expression