Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

not equal in set analysis

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)

3 Replies
Not applicable

not equal in set analysis

You can write it as either:

STATUS-={SL}

or

~STATUS={SL}

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

Kiran

christophebrault
Valued Contributor

not equal in set analysis

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

Not applicable

not equal in set analysis

Hi Dhanupriya,

Use the following,

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

BR,

Abhi

Community Browser