topic Re: Not equal to in set Analysis in QlikView

Not equal to in set Analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hi Community

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

Thanks

Re: Not equal to in set Analysis

amayuresh — Wed, 16 Mar 2016 09:04:32 GMT

Please Post your expression and Sample data

Re: Not equal to in set Analysis

MK_QSL — Wed, 16 Mar 2016 09:04:58 GMT

<> 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.

Re: Not equal to in set Analysis

Wed, 16 Mar 2016 09:05:42 GMT

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

Thanks

Re: Not equal to in set Analysis

Chanty4u — Wed, 16 Mar 2016 09:06:48 GMT

u can use

-= symbol to not equall

Re: Not equal to in set Analysis

ali_hijazi — Wed, 16 Mar 2016 09:08:10 GMT

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)

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

Re: Not equal to in set Analysis

Wed, 16 Mar 2016 09:10:27 GMT

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

Re: Not equal to in set Analysis

sunny_talwar — Wed, 16 Mar 2016 10:01:47 GMT

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.

Re: Not equal to in set Analysis

engishfaque — Wed, 16 Mar 2016 11:37:30 GMT

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

Re: Not equal to in set Analysis

Gabriel — Wed, 16 Mar 2016 13:02:19 GMT

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

Re: Not equal to in set Analysis

moojahid2 — Wed, 19 Dec 2018 12:33:36 GMT

Sureshqv is Ryt. In set analysis <> not work. Instead -= means not equal or exclude

for example
Sum({$<[Delivery status] -= {"Not delivered"}>}[Sales Amount])/ Sum([Sales Amount])