Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need Assistance in Count Function

Hi Experts,

I do have table as below and need to count the customers who has returned the product from total sales.

  

ProductYearMonthValue
Item 12015JAN-1
Item 22015JAN10
Item 32015JAN20
Item 42015JAN30
Item 52015JAN-40
Item 62015JAN50
Item 72015JAN60
Item 12015JAN70
Item 22015JAN-80
Item 32015JAN90
Item 42015JAN-100
Item 52015JAN110
Item 62015JAN120
Item 72015JAN130
Item 12015JAN140
Item 22015JAN150
Item 32015JAN-160
Item 42015JAN170
Item 52015JAN180
Item 62015JAN-190
Item 72015JAN200

The out put which i would like to get as below :

In Label:

No Returned Products: 2

   

MonthTotal ValueTotal
Item 1          209
Item 280
Item 3-50
Item 4100
Item 5250
Item 6-20
Item 7390
JAN Total

95

Thanks

Raju .K

1 Solution

Accepted Solutions
sunny_talwar

Looking for this?

Capture.PNG

Expression: =Sum(If(Aggr(Sum(Value), Product) < 0, 1, 0))

View solution in original post

7 Replies
sunny_talwar

Looking for this?

Capture.PNG

Expression: =Sum(If(Aggr(Sum(Value), Product) < 0, 1, 0))

Anonymous
Not applicable
Author

you would the Basic table with

SalesPerMonth:

noconcatenate load

Month,

Product,

sum(Value)

resident Yourtable

Group by Month, Product

drop table yourtable

But how do you recognize returned products? by negative sum per month?

then in a textbox

if (sum(Value)<0, Count(Product))

qlikviewwizard
Master II
Master II

Hi Raju,

Try like this in Pivot Table.

Hope this will help you. Thank you.

Capture.PNG

Anonymous
Not applicable
Author

Excellent Sunny Thanks a lot

Anonymous
Not applicable
Author

Thanks Rudolf

Anonymous
Not applicable
Author

Thanks Mate

sunny_talwar

No problem

I am glad I was helpful.

Best,

Sunny