Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
semgem12
Contributor III
Contributor III

Set Analysis with Count

Hello

Hope someone can help please.

I have a table that has part numbers and for each part number it has the total stock available, e.g.

PartNumber, Stock

100001,200

100002,150

100003,320

etc.

In Qlik Sense I want to create a number of text boxes that show various counts. They are all very similar and show the number of parts that have a stock count between one value and another. E.g. the number of parts that have a stock count between 100 and 200.

So far I have this,

=count({<PartNumber = {"=sum(Stock) >100"} >} distinct PartNumber)

which counts the number of parts with stock over 100.

But how do I change this to say >100 and < 200? Or is there another way to achieve the same thing?

Thanks.

1 Solution

Accepted Solutions
devarasu07
Master II
Master II

Hi,

Try like below

=count({$<Stock = {">100<200"}>} distinct PartNumber)

to show in text with custom string value like below

='# of parts stock count between 100 & 200 is :'& chr(10)& count({$<Stock = {">100<200"}>} distinct PartNumber)

Capture.JPG

View solution in original post

4 Replies
devarasu07
Master II
Master II

Hi,

Try like below

=count({$<Stock = {">100<200"}>} distinct PartNumber)

to show in text with custom string value like below

='# of parts stock count between 100 & 200 is :'& chr(10)& count({$<Stock = {">100<200"}>} distinct PartNumber)

Capture.JPG

sunny_talwar

May be this

=Count({<PartNumber = {"=Sum(Stock) >100 and Sum(Stock) < 200"}>} distinct PartNumber)

semgem12
Contributor III
Contributor III
Author

Thank you! That has worked fine.

semgem12
Contributor III
Contributor III
Author

Thank you but unfortunately that has not worked. It returns zero.