Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Can someone please help me with the following load statement:
Groupings2:
Load *,
If(0 <= seats_reamaining <= 10 , 'A',
If(10 < seats_reamaining <= 20 , 'B',
If(20 < seats_reamaining <= 30 , 'C',
If(30 < seats_reamaining <= 40 , 'D',
If(40 < seats_reamaining <= 50 , 'E',
If(50 < seats_reamaining <= 60 , 'F',
If(60 < seats_reamaining <= 70 , 'G',
If(70 < seats_reamaining <= 80 , 'H',
If(80 < seats_reamaining <= 90 , 'I',
If(90 < seats_reamaining <= 100 , 'J',
If(100 < seats_reamaining <= 110 , 'K',
If(110 < seats_reamaining <= 120 , 'L',
If(120 < seats_reamaining <= 130 , 'M',
If(130 < seats_reamaining <= 140 , 'N',
If(140 < seats_reamaining <= 150 , 'O',
If(150 < seats_reamaining <= 160 , 'P',
If(160 < seats_reamaining <= 170 , 'Q',
If(170 < seats_reamaining <= 180 , 'R', 'Cannot Calculate')))))))))))))))))) as Seat_Class
Resident Groupings1;
I keep getting the following error:
Error in expression:
')' expected
I don't understand this as the correct number of parenthesis is included to close all the if statements. Any help will be greatly appreciated.
ps I'm fairly new to QV.
Hi,
As per the Question by @Andre, It should be 'Cannot Calculate'
....
If(seats_reamaining < 0, 'Cannot Calculate'
If( seats_reamaining <= 10 , 'A',
....
Hi Jagan,
Here
If(seats_reamaining >= 0,
If( seats_reamaining <= 10 , 'A',
If(seats_reamaining <= 20 , 'B',
If(seats_reamaining <= 30 , 'C',
If(seats_reamaining <= 40 , 'D',
If(seats_reamaining <= 50 , 'E',
If(seats_reamaining <= 60 , 'F',
If(seats_reamaining <= 70 , 'G',
If(seats_reamaining <= 80 , 'H',
If(seats_reamaining <= 90 , 'I',
If(seats_reamaining <= 100 , 'J',
If(seats_reamaining <= 110 , 'K',
If(seats_reamaining <= 120 , 'L',
If(seats_reamaining <= 130 , 'M',
If(seats_reamaining <= 140 , 'N',
If(seats_reamaining <= 150 , 'O',
If(seats_reamaining <= 160 , 'P',
If(seats_reamaining <= 170 , 'Q',
If(seats_reamaining <= 180 , 'R', 'Cannot Calculate'))))))))))))))))))) as Seat_Class
if i am using above
If( seats_reamaining <= 10 , 'A', --- will it take only below 10 right?
If(seats_reamaining <= 20 , 'B', --- wat about this it will take 0-20 right?
but evry where 0-10 is repeating ?
Hi Shravan,
If(seats_reamaining <= 20 , 'B', --- it will take 11 to 20 , as 10 will come in -- If( seats_reamaining <= 10 , 'A',