Count

[#1]

Hi All,

can any one help me to get the expression to find the count,

I have a table like below , if a person has active Product sales less than 3000 for consecutive dates then count is 1 if not count is zero.

how to achieve this with set analysis.

        Edited: 

Expected Result is

A	2
B	1
C	1
D	1

Date	Active Productsales	Person
3/16/2013	1100	A
3/17/2013	2500	A
3/18/2013	2000	B
3/19/2013	2000	B
3/20/2013	2000	A
3/21/2013	3500	B
3/22/2013	2900	A
3/23/2013	2500	A
3/24/2013	2500	C
3/25/2013	2500	C
3/26/2013	3250	D
3/27/2013	2500	D
3/28/2013	2640	D
3/29/2013	2500	D
3/30/2013	6000	C
3/31/2013	4200	D

[prajapatiamar38]

Hi

=count({<ActiveProductSales={'<3000'}>}Person)

try this

[sunilkumarqv]

Check

[padmanabhan_ram]

Hope this is what you expect

[prajapatiamar38]

Hi sorry try this:

=count(DISTINCT {< ActiveProductSales={'<3000'} >}Person)

[#6]

Thanks Padmanabhan Ramakrishnan.

No it is not working, and it is not checking consecutive dates  ,  if I change the below product sales value to 1500 count should be 2 for A, but it is not showing it.

3/16/2013

5000

A

[#7]

Thanks Amarnath Prajapati,

No it is not working, and it is not checking consecutive dates  ,  if I change the below product sales value to 1500 count should be 2 for A, but it is not showing it.

3/16/2013

5000

A

[malini_qlikview]

Hi,

Try this in the expression of the straight table,

=If(Above(Num(If(Sum([Active Products])<3000,Day(Date))))+1=Day(Date),1,0)

See attached,

You can hide the date column in the table finally.

[#9]

Thanks Malini Chandrasekar,

No it is not working, and it is not checking consecutive dates  ,  if I change the below product sales value to 1500 count should be 2 for A, but it is not showing it.

3/16/2013

5000

A

and I want out put like above, I don't want to see the repeated persons.

[krishna20]

Hi,

Please find the attached app.

Regards

Krishna