Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
rajukuppusamy1
New Contributor III

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

Re: Need Assistance in Count Function

Looking for this?

Capture.PNG

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

View solution in original post

7 Replies

Re: Need Assistance in Count Function

Looking for this?

Capture.PNG

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

View solution in original post

Partner
Partner

Re: Need Assistance in Count Function

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
Honored Contributor II

Re: Need Assistance in Count Function

Hi Raju,

Try like this in Pivot Table.

Hope this will help you. Thank you.

Capture.PNG

rajukuppusamy1
New Contributor III

Re: Need Assistance in Count Function

Excellent Sunny Thanks a lot

rajukuppusamy1
New Contributor III

Re: Need Assistance in Count Function

Thanks Rudolf

rajukuppusamy1
New Contributor III

Re: Need Assistance in Count Function

Thanks Mate

Re: Need Assistance in Count Function

No problem

I am glad I was helpful.

Best,

Sunny