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: 
sunny_talwar

Re: Meeting Multiple Criteria

May be a set analysis like this

{<SKU = {"=Count({<SKU = P({<[Active Loc.] = {[M*]}>})>}[Active Loc.]) > 0"}>}

image.png

35 Replies
dylannelson
Contributor II
Contributor II

 
sunny_talwar
Author

Do you expect to see 316 SKU after you select the button? Try attached

dylannelson
Contributor II
Contributor II

Hey Sunny,

 

I believe what you've done has worked. I did see a couple of outliers. The image below shows 6 of the same SKU's, but doesn't have a M1 location. 

 

 

dylannelson
Contributor II
Contributor II

Qlikview Ex3.PNG

sunny_talwar
Author

I see one M1*... what is the issue?

Capture.PNG

dylannelson
Contributor II
Contributor II

Hey Sunny,

Sorry I thought I replied back. Thank you so much for you help! I miss clicked on a filter. It's working great!!!!

 

Thanks again!