Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

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

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

tsoley341854
New Contributor III

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

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],