Not equal to in set Analysis

[#1]

Hi Community

Please find the attached and advice where i can put the not equal to operator .

Thanks

[amayuresh]

Please Post your expression and Sample data

[MK_QSL]

<> in set analysis can be written as -=

=Count({<Task={'TS00207914'},[Work Status]-={'COmpleted'} ,[Create Date]={$(vYesterday)}, [Create Time]={'>=06:00:00<=00:00:00'}>}ID)

+

Count({<Task={'TS00207914'}, [Work Status]-={'COmpleted'} ,[Create Date]={$(vToday)} ,[Create Time]={'<=06:00:00'}>}ID)

NOTE : QlikView is case sensitive.. so COmpleted is different than COMPLETED.

You need to write in correct case.

[#4]

i have attached a QVW file , the expression i wrote it in the text  object

Thanks

[Chanty4u]

u can  use

-=   symbol to not equall

[ali_hijazi]

Not equal in set analysis is written as following for example:

I want to see the sales where Produce_Category is not Shoes

Sum({<Produce_Category={'*'}-{'Shoes'}>}Sales)

or

Sum({<Product_Category-={'Shoes'}>}Sales)

[#7]

Hi can you please try to put it in the attached file i attached and see if it works ?

[sunny_talwar]

Like Manish said, you can use this:

=Count({<Task={'TS00207914'},[Work Status]-={'COMPLETED'} ,[Create Date]={$(vYesterday)}, [Create Time]={'>=06:00:00<=00:00:00'}>}ID)

+

Count({<Task={'TS00207914'}, [Work Status]-={'COMPLETED'} ,[Create Date]={$(vToday)} ,[Create Time]={'<=06:00:00'}>}ID)

But currently you are seeing 0 because you don't have data for today's date in your sample application.

[engishfaque]

Dear Mutshidzi,

We use -= in set analysis to exclude field values such as given below,

Expression1:

=Sum ({<Year = {2015}>} Sales) //means return sum of sales where year = 2015

Expression2:

=Sum ({<Year -= {2015}>} Sales) //means return sum of sales for all years but exclude sales where year is equal to 2015

Kind regards,

Ishfaque Ahmed

[Gabriel]

Hi,

All the suggestions above is excellent, using -= as a replacement for <>. One thing I will like to add is, if you're dealing with large data set, I think you should create another field in the script and use binary as value of the field.

IF( [Work Status] <> 'COMPLETE' , 1,0)                AS Whatever

Then in your Set Analysis just use the Whatever ={1}.

Hope this helps