Discussion Board for collaboration related to QlikView App Development.
Hello,
i want to count all distinct SKU's based on this:
Count(DISTINCT {<date={">=$(=VDatumSeizoenHuidigVan)<=$(=VDatumSeizoenHuidigTot)"}>} sku_code )
that works but it also gives me SKU's that don't have orderlines associated with them.
How should i need to adapt the count formula so that it only counts those SKU's where below qty is greater than zero?
sum ( {<date={">=$(=VDatumSeizoenHuidigVan)<=$(=VDatumSeizoenHuidigTot)"}>} (qty_unit-qty_unit_cancelled))
Thanx a lot!
chris
You need to put the same condition in set , like:
Count(DISTINCT {<sku_code={`=sum ( {<date={">=$(=VDatumSeizoenHuidigVan)<=$(=VDatumSeizoenHuidigTot)"}>} (qty_unit-qty_unit_cancelled))>0` },
date={">=$(=VDatumSeizoenHuidigVan)<=$(=VDatumSeizoenHuidigTot)"}>} sku_code )
Note, the back quotes in red. You could use another valid quote though.
You need to put the same condition in set , like:
Count(DISTINCT {<sku_code={`=sum ( {<date={">=$(=VDatumSeizoenHuidigVan)<=$(=VDatumSeizoenHuidigTot)"}>} (qty_unit-qty_unit_cancelled))>0` },
date={">=$(=VDatumSeizoenHuidigVan)<=$(=VDatumSeizoenHuidigTot)"}>} sku_code )
Note, the back quotes in red. You could use another valid quote though.
ok, that worked perfectly!
Thanx a lot!!
Chris