topic Count orders only with discount in QlikView

Count orders only 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.

Re: Count orders only with discount

lironbaram — Wed, 14 Mar 2018 13:35:32 GMT

hi you can do it like this

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

Re: Count orders only with discount

madhuqliklondon — Wed, 14 Mar 2018 13:50:06 GMT

Hi,

I am counting orders with count(DISTINCT [Order number]) and orders with discount with count({<[Discount amount]={">0"}>}distinct [Order number]) , for some reason I have same count of number of orders in both .

Re: Count orders only with discount

Anonymous — Wed, 14 Mar 2018 13:57:13 GMT

Hi,

Use the below code.

Count(Distinct If([Discount Amount] > 0 , [Order Number]))

Thanks,

Venkata Sreekanth

Re: Count orders only with discount

madhuqliklondon — Wed, 14 Mar 2018 15:43:33 GMT

Thank you Sreekanth