topic Re: Load Data in QlikView

Load Data

Anonymous — Fri, 22 Dec 2017 10:52:56 GMT

What could be the possible problem when the if condition goes wrong?

I have this number 9590.101010...But Rank keep showing J.

Some numbers are correct, some are not.

Range1: 460

Range2: 13280

...

Range10: 134,509

If (value >= Range1 AND value < Range2) Then

Rank = "A"

ElseIf (value >= Range2 AND value < Range3) Then

Rank = "B"

ElseIf (value >= Range3 AND value < Range4) Then

Rank = "C"

ElseIf (value >= Range4 AND value < Range5) Then

Rank = "D"

ElseIf (value >= Range5 AND value < Range6) Then

Rank = "E"

ElseIf (value >= Range6 AND value < Range7) Then

Rank = "F"

ElseIf (value >= Range7 AND value < Range8) Then

Rank = "G"

ElseIf (value >= Range8 AND value < Range9) Then

Rank = "H"

ElseIf (value >= Range9 AND value < Range10) Then

Rank = "I"

Else Rank = "J"

End If

Re: Load Data

marcus_sommer — Fri, 22 Dec 2017 12:09:20 GMT

It could be that either value or your various Range aren't interpreted as number or in the wrong way. Where did you try to apply this kind of logic because it don't look like valid qlik-code respectively how does your real code look like?

- Marcus

Re: Load Data

Anonymous — Fri, 22 Dec 2017 23:05:08 GMT

Hi Marcus,

You're right. Tried to format all the Range and it works. Thanks