topic ? in QlikView

?

xyz1 — Sun, 14 Apr 2019 16:31:03 GMT

Re: if

Anonymous — Tue, 05 Dec 2017 07:17:42 GMT

Try this,

IF("Schedule Variance">='0%', ' Ahead Of Schedule',IF("Schedule Variance"<'-10%', 'BehindSchedule','On Schedule'

)) as Schedule_Classification

Re: if

Anil_Babu_Samineni — Tue, 05 Dec 2017 07:25:30 GMT

Normally percentage calculate in Decimal like 10$ - 0.1 and so on. I assume, In your case it has like below

IF("Schedule Variance">=0.0, ' Ahead Of Schedule', IF("Schedule Variance"=1, 'On Schedule', IF("Schedule Variance"< (-0.1), 'BehindSchelule'))) as Schedule_Classification

Re: if

Anonymous — Tue, 05 Dec 2017 07:27:44 GMT

Try this...

IF("Schedule Variance">='0%', ' Ahead Of Schedule',

IF("Schedule Variance"<='-10%' and "Schedule Variance" <'0%','On Schedule',

IF("Schedule Variance"<'-10%', 'BehindSchelule')

)) as Schedule_Classification