Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Count orders with discount

Hi All,

I want to Count orders with discount only.

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

Thanks in advance.

1 Solution

Accepted Solutions
Champion
Champion

Hi,

you can try this:

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

View solution in original post

3 Replies
Champion
Champion

Hi,

you can try this:

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

View solution in original post

Master III
Master III

May be this -

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

Master
Master

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