topic not equal in set analysis in QlikView

not equal in set analysis

Fri, 25 Nov 2011 04:49:36 GMT

how i can use not equal in this expression with status i have tried with '<>' and '-=' but its not working.

i don know where i am doing mistake, can you please help me out of it.

SUM({<SALES_YEAR={'$(VMaxYear)'},SALES_MONTH=,SALES_DAY=,DATE={'<=$(VMaxDate)'},SALESYEARMONTH=,STATUS {SL}>}SALES_AMOUNT)

Fri, 25 Nov 2011 05:23:10 GMT

You can write it as either:

STATUS-={SL}

~STATUS={SL}

Since the former didnt work for you please try the latter.

Kiran

christophebrault — Fri, 25 Nov 2011 14:34:24 GMT

IF SL is a fieldvalue, try STATUS<>{'SL'} or STATUS={'*'}-{'SL'}

Mon, 05 Dec 2011 05:46:36 GMT

Hi Dhanupriya,

Use the following,

STATUS=E({1<STATUS={"SL"}>})

BR,

Abhi