topic Re: filter condition in QlikView

filter condition

rathnam_qv — Mon, 08 Jul 2013 09:22:14 GMT

hi all,

i have Month as Listbox, it contain all month names but i want to show JAN and FEB only how can i achieve this

please help me...

Thanks in advance

smiley

Mon, 08 Jul 2013 09:26:30 GMT

if(match(Month,'JAN','FEB'),Month) as Month_new

tresB — Mon, 08 Jul 2013 09:27:09 GMT

Goto tab ''General' ->Field-> Select Expression:

If(Month='JAN' or Month='FEB', Month)

Thanks.

Sokkorn — Mon, 08 Jul 2013 09:28:49 GMT

Hi Munirathnam,

Create list box with expression =If(Match(Month,'JAN','FEB'),Month,Null())

Regards,

Sokkorn