topic Set Analysis Greater Than or Equal To in QlikView

Set Analysis Greater Than or Equal To

dylannelson — Sat, 16 Nov 2024 04:01:48 GMT

Hello Qlikview Team!

Tying to figure out this expression! I currently have this.

Avg({<SKU = {"=Count({<SKU = P({<[Active Loc.] = {[M10211 >= M14355]}>})>}[Active Loc.])>1"}> }1)

With this expressions I'm trying to find all Duplicate SKU's in Active Loc. - - - This does work when trying find [M*], but when I try to tell the system I want to see M10211 >= M14355 I get zero records when I know I have records that contain in between the range of numbers.

Thanks Team,

Re: Set Analysis Greater Than or Equal To

pradosh_thakur — Thu, 28 Mar 2019 08:01:43 GMT

You need to be more clear. May be give us an example to understand. Answering you with assumption will not help.

Re: Set Analysis Greater Than or Equal To

dylannelson — Mon, 08 Apr 2019 18:37:49 GMT

I hope this example helps.