topic Re: set filter in QlikView

set filter

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have below expression in my table ,,so I want to include the some filter value within it how can I do this?

.if(Time>=Normal and Time<=Urgent,number,0)

in above Type={'VM','SO'} how to include this in above expression?

Thanks

Sonica

sunny_talwar — Tue, 18 Jul 2017 14:01:48 GMT

May be like this

Only({<Type={'VM','SO'}>} If(Time >= Normal and Time<= Urgent, number, 0))

soniasweety — Wed, 19 Jul 2017 03:37:00 GMT

tq sunny,

if I want to write that with setanalysis total exp without if? how can I write?

Kushal_Chawda — Wed, 19 Jul 2017 07:09:59 GMT

You can create one field in script for if condition

LOAD ..

if(Time>=Normal and Time<=Urgent,number,0) as number_final

...

Now you can write the expression as

=sum({<Type={'VM','SO'} >} number_final)

PrashantSangle — Wed, 19 Jul 2017 07:18:06 GMT

If Time,Normal and Urgent all three field coming from one table then create flag in script

if(Time>=Normal and Time<=Urgent,'1','0') as flag

then your set expression try like

only({<flag={"1"},Type={'VM','SO'}>}number)

Regards,

soniasweety — Wed, 19 Jul 2017 09:24:51 GMT

thanks all for clear explanations

Thanks

Sonica !!