topic Re: Limiting filter in multibox in QlikView

Limiting filter in multibox

srikantj — Thu, 23 Mar 2017 10:59:14 GMT

Hi qlikss.

I have a field named "quantity" and it has both negative and positive values and zeroes

quantity

-45

-54

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

sunny_talwar — Thu, 23 Mar 2017 11:06:33 GMT

Use an if statement

If(quantity < 0, '<0', '>=0')

bhupesh_gupta — Thu, 23 Mar 2017 11:11:40 GMT

Hi Srikanth

There are various ways of doing this.. A very basic one is to use IF ELSE statement in the precedence load,something like this,

load *,

if(quantity<0,'<0',if(quantity>=0,'>=0')) as TEST;

LOAD * INLINE [

quantity

-45

-54

];

Regards

Bhupesh

srikantj — Thu, 23 Mar 2017 12:15:03 GMT

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

sunny_talwar — Thu, 23 Mar 2017 12:24:51 GMT

Can you share a sample where this is happening for you?