Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

?

.

1 Solution

Accepted Solutions
qlik_aparnav
Creator II
Creator II

Try this,

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

          )) as Schedule_Classification

View solution in original post

3 Replies
qlik_aparnav
Creator II
Creator II

Try this,

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

          )) as Schedule_Classification

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
johnhhtp2
Creator II
Creator II

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