Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
xyz1
Creator III
Creator III

?

.

25 Replies
Anil_Babu_Samineni

Where is your qvf?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
xyz1
Creator III
Creator III
Author

.

xyz1
Creator III
Creator III
Author

.

Anil_Babu_Samineni

Sorry, From here what was the error you faced? What you are expecting to see

Script is ok to me

And even Formula is fine for me

IF (Classification <= 0.25 , '0-25%' ,

IF (Classification  >= 0.26 and  Classification <= 0.50,  '26-50%',

IF (Classification  >= 0.51 and  Classification <= 0.75,  '51-75%',

IF (Classification  >= 0.76 and  Classification <= 1,  '76-100%',

'Null'))))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
xyz1
Creator III
Creator III
Author

.

xyz1
Creator III
Creator III
Author

.

jonathandienst
Partner - Champion III
Partner - Champion III

you might be hitting rounding problems which your bucket statement may not handle. i would simplify the statement (as well as make it more reliable). In load script:

If(Classification <= 0.25 , '0-25%' ,

     If(Classification <= 0.50,  '26-50%',

     If(Classification <= 0.75,  '51-75%',  '76-100%'))) as Class

This assumes that call values of Classification are between 0 and 1.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
xyz1
Creator III
Creator III
Author

.

jonathandienst
Partner - Champion III
Partner - Champion III

Is that your complete load script?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
xyz1
Creator III
Creator III
Author

.