Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe something like this?
Count(if( IsNum(Size),Size))
Can you post your application?
Post my application? I use Qlik Sense...
Below is what I get using your "Count(if(IsNum(Size),Size))".
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
Hi Karley,
Try:
Count(if(IsNum(ItemSize),ItemSize))
Cheers
Andrew
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.
I agree with your contribution