topic Re: Using <> as different from in Set analysis doesnt work? in QlikView

Using <> as different from in Set analysis doesnt work?

Thu, 20 Feb 2014 11:52:21 GMT

I´m trying to use <> as different from in a Set Analysis but get error in expression set modifier

COUNT({<verd_del <> {'Dk'}, age = {'17','16','15','14'}>} item)

How du I do this?

mambi — Thu, 20 Feb 2014 11:58:14 GMT

Hi try this one ,

COUNT({<verd_del -={'Dk'}, age = {'17','16','15','14'}>} item)

struniger — Thu, 20 Feb 2014 11:58:18 GMT

Try -= instead of <>

Here's a cool tool for set analyses:

Best regards

Stefan

bumin — Thu, 20 Feb 2014 12:06:53 GMT

just be aware Qlikview doesn't recognize it as right (it shows expression failure) but it works

MK_QSL — Thu, 20 Feb 2014 12:18:54 GMT

COUNT({<verd_del -= {'Dk'}, age = {'17','16','15','14'}>} item)

aveeeeeee7en — Thu, 20 Feb 2014 12:33:08 GMT

Dear Soren

Set Analysis does not support <>

In Set Analysis Not equal to is represented by '-='

Your Expression should be:

COUNT(${<verd_del-={'Dk'}, age = {'17','16','15','14'}>} item)

Regards

Aviral Nag

sunilkumarqv — Fri, 21 Feb 2014 13:13:00 GMT

Try This

COUNT({<verd_del={"*"}-verd_del= {'Dk'}, age = {'17','16','15','14'}>} item)

BryanFontes — Mon, 27 Sep 2021 12:00:34 GMT

Nice!