Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Appropriate way to use "less than", "more than" logic in script

Hi All,

Im trying do some formula and put the value in the field. However when I it looks like value was not correct.

SET variable1 = ( ValueA < 010 and ValueC = TEST);


SET variable2 = $(variable1) and  I convert variable2 to field call [FIELD-A].


However when I check my field it also display ValueA as > 010.


Is it correct way to declare the logic in script qlikview?



2 Replies
sunny_talwar

Can you share the exact script you are trying right now?

Anonymous
Not applicable
Author

Here is some script that I used on my last APP ...hope this help's

   if(RESEGMENTED_FIRST_TIME_THIS_MONTH_IND = 'Y' AND ASSIGNMENT_DATE > '1' , '1', '0') AS [Up Segmented Count],