topic Re: Meeting Multiple Criteria in QlikView

Re: Meeting Multiple Criteria

sunny_talwar — Wed, 25 Nov 2020 16:16:04 GMT

May be a set analysis like this

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

Re: Meeting Multiple Criteria

dylannelson — Wed, 20 Mar 2019 13:22:40 GMT

I believe you hit this on the HEAD!!! I have one more question..... Could you add in the statement so that it pulls anything for "N" as well. It's currently pulling everything associated with "M", but can it look at "M", and "N"?

Re: Meeting Multiple Criteria

sunny_talwar — Wed, 20 Mar 2019 13:56:11 GMT

Change to this

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

Re: Meeting Multiple Criteria

dylannelson — Wed, 20 Mar 2019 14:21:19 GMT

Thank you Thank you! It works!! I do have to ask what is {<SKU = {"=Count({<SKU = P({<[Active Loc.] = {[M*], [N*]}>})>}[Active Loc.]) > 0"}>}…….. SKU = P referencing?... sorry for all the questions just trying learn.

Re: Meeting Multiple Criteria

sunny_talwar — Wed, 20 Mar 2019 14:23:46 GMT

Read about this here

P() & E() and where do you use them

Re: Meeting Multiple Criteria

dylannelson — Wed, 20 Mar 2019 15:15:37 GMT

Thank you for sharing! I'm unable to select the "solution solved" on the formula that you've sent me. =(

Re: Meeting Multiple Criteria

dylannelson — Wed, 20 Mar 2019 18:59:54 GMT

Hey Sunny,

How can I suppress Active Loc's that only have one SKU? You'll see this with most of the M, and N locations?

This image below shows an example of where only one sku/one location is being populated. I want all of these removed.

Re: Meeting Multiple Criteria

sunny_talwar — Wed, 20 Mar 2019 19:11:14 GMT

May be this

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

Re: Meeting Multiple Criteria

dylannelson — Wed, 20 Mar 2019 19:21:37 GMT

Yeah, unfortunately it's still populating SKU's with only 1 Active loc.. I was wondering if there's a statement that can say it must be > 1 SKU?

Re: Meeting Multiple Criteria

sunny_talwar — Thu, 21 Mar 2019 11:04:48 GMT

I removed one row for SKU = 00-28231058 where Active Loc. = P28421 and that seemed to have worked for me. Look at the attached app where SKU = 00-28231058 only have M64525 and doesn't show up on my chart 🙂

Re: Meeting Multiple Criteria

dylannelson — Mon, 25 Mar 2019 18:57:34 GMT

Hey Sunny, It Worked!!!

Do you know how to create a count based off of same SKU? For example the image below has 4 of the same SKU's I want a column that shows how many of the same SKU exist so the count would be 4.

Re: Meeting Multiple Criteria

sunny_talwar — Mon, 25 Mar 2019 19:02:55 GMT

I don't think I follow? Where would it show 4? In another chart? KPI object?

Re: Meeting Multiple Criteria

dylannelson — Mon, 25 Mar 2019 19:23:43 GMT

I hope this image shows a better example. I don't care if it's in a different chart as long as it can filter Greatest to Least.

Re: Meeting Multiple Criteria

sunny_talwar — Mon, 25 Mar 2019 19:31:10 GMT

What is your current expression that you are using?

Re: Meeting Multiple Criteria

dylannelson — Mon, 25 Mar 2019 19:48:44 GMT

I only have one expression. This expression doesn't have anything to do with a counting the SKU's. I guess that's my question. What would the expression be to make this type of calculation? All I need it to do is count how many of a given SKU. Just like the last image had shown. This should be really simple, but I'm the noob...

Re: Meeting Multiple Criteria

dylannelson — Mon, 25 Mar 2019 21:48:13 GMT

Hey Sunny,

If you could check this link out. This is my question.

https://community.qlik.com/t5/Qlik-Sense-App-Development/count-duplicates-in-a-column/td-p/1414069

Re: Meeting Multiple Criteria

sunny_talwar — Tue, 26 Mar 2019 00:02:58 GMT

So, you are looking for the same number to repeat for each of the SKU? Try using the TOTAL function...

Sum(TOTAL <SKU> {<...>} 1)

Re: Meeting Multiple Criteria

dylannelson — Tue, 26 Mar 2019 12:06:30 GMT

Hey Sunny,

Thank you! I ended up using this Count(TOTAL<SKU>DISTINCT [Active Loc.]). Is there a way to use a column created from and expression as a dimension? I need to create a Bucket List that I can select (1-5) (6-10) (11-15). I was thinking this would have to be in the load, but I don't believe I can use Count(TOTAL<SKU>DISTINCT [Active Loc.]) in the load?

Re: Meeting Multiple Criteria

sunny_talwar — Tue, 26 Mar 2019 12:29:35 GMT

You can do this using Aggr() function in the calculated dimension

Re: Meeting Multiple Criteria

dylannelson — Tue, 26 Mar 2019 13:08:37 GMT

Hey Sunny,

Would you be able to show me an example? I've been trying to add the Aggr function, but no luck.