Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
dylannelson
Contributor II
Contributor II

Set Analysis Greater Than or Equal To

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,

Labels (2)
2 Replies
pradosh_thakur
Master II
Master II

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

Learning never stops.
dylannelson
Contributor II
Contributor II
Author

 

I hope this example helps.

Qlikview Ex1.PNG