topic Re: Count orders with discount in QlikView

Count orders with discount

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

Hi All,

I want to Count orders with discount only.

I have field names [Order number] ,[Sales amount] and [Discount amount].

Thanks in advance.

YoussefBelloum — Wed, 14 Mar 2018 14:03:34 GMT

Hi,

you can try this:

Count( {<[Order number]={"=sum( [Discount amount])>0"}>} [Order number])

Digvijay_Singh — Wed, 14 Mar 2018 14:04:34 GMT

May be this -

Count({<[Discount amount={">0"}>}distinct [Order number] )

shiveshsingh — Wed, 14 Mar 2018 16:08:09 GMT

Count(if([Discount amount].)>0,[Order Number])