Discussion Board for collaboration related to QlikView App Development.
I have a field named "quantity" and it has both negative and positive values and zeroes
I used it in my multibox. it is showing all 5 values
But i want only two options 1) <0 2) >=0 I want only these two options not all values
Based on this my chart should vary ... Suggest Qliksssss
Go to Solution.
Use an if statement
If(quantity < 0, '<0', '>=0')
View solution in original post
There are various ways of doing this.. A very basic one is to use IF ELSE statement in the precedence load,something like this,
if(quantity<0,'<0',if(quantity>=0,'>=0')) as TEST;
LOAD * INLINE [
hi sunny ,
it is working fine .. still 10 to 15 negative values are coming for >=0
i am using Expression in straight table not field as filter
Can you share a sample where this is happening for you?