Variables as part of an IF expression

Thu, 04 Jul 2013 08:27:10 GMT

Hi everyone,

I have the following IF statement that I would like to use. I have a table with an expression =$(vPatientAge) which works fine. From this I wanted to set up some age groups, so I wrote this:

(AGE(IncDate,$(vPatientAge))<0, 'INVALID',
IF(AGE(IncDate,$(vPatientAge))<18, '0-17',
IF(AGE(IncDate,$(vPatientAge))<65, '18-64',
IF(AGE(IncDate,$(vPatientAge))<100, '65-99',
IF(AGE(IncDate,$(vPatientAge))<120, '100-120', 'OVER 120')))))

The IF statement only returns a value of 'OVER 120' what ever the value returned by the variable. Am I doing something wrong in the expression that anyone can see?

Many thanks

Phil

Re: Variables as part of an IF expression

Gysbert_Wassenaar — Thu, 04 Jul 2013 09:13:36 GMT

Please post an example document:

Preparing examples for Upload - Reduction and Data Scrambling

topic Variables as part of an IF expression in QlikView

Variables as part of an IF expression

Re: Variables as part of an IF expression