Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum, mode, count question

Trying to count the number of sizes; however, I do not want to include in the count the sizes that doesn't come in a particular size. The image below shows a dress that comes in numeric sizing; however, the count function is counting the zeros in sizes XS-L. Is there a syntax, similar to the mode function that'll allow me to count only the inventory within the sizes most common of a number or a letter? The count I need is 8, not 12. If size "6" showed zero, then my count would be 8 with 1 count with zero inventory.

2017-10-20 14_29_44-.png

6 Replies
lorenzoconforti
Specialist II
Specialist II

Maybe something like this?

Count(if( IsNum(Size),Size))

Can you post your application?

Anonymous
Not applicable
Author

Post my application? I use Qlik Sense...

Below is what I get using your "Count(if(IsNum(Size),Size))". 

2017-10-20 16_45_32-NewDemandData - Size Run Status FASHION _ Sheets - Qlik Sense.png

lorenzoconforti
Specialist II
Specialist II

I see; I got confused as this is actually the QlikView forum. I think you can still upload your qvf file.

Probably best to re-post on the QlikSense forum

effinty2112
Master
Master

Hi Karley,

Try:

Count(if(IsNum(ItemSize),ItemSize))

Cheers

Andrew

swuehl
MVP
MVP

Maybe something like

=Count( DISTINCT If( Isnum(ItemSize),ItemSize))

or using set analysis:

=Count({<ItemSize  = {"=Isnum(ItemSize)"}>} DISTINCT ItemSize)

or

=Count({<ItemSize  = {">0"}>} DISTINCT ItemSize)



If this doesn't work, would be good to see your expression that shows the 12 total count.

uroboros
Creator
Creator

I agree with your contribution