topic Re: Count in QlikView

Count

Tue, 08 Sep 2015 12:04:07 GMT

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

Re: Count

prajapatiamar38 — Tue, 08 Sep 2015 12:15:32 GMT

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

try this

Re: Count

sunilkumarqv — Tue, 08 Sep 2015 12:16:49 GMT

Check

Re: Count

padmanabhan_ram — Tue, 08 Sep 2015 12:25:01 GMT

Hope this is what you expect

Re: Count

prajapatiamar38 — Tue, 08 Sep 2015 12:25:24 GMT

Hi sorry try this:

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

Re: Count

Tue, 08 Sep 2015 12:55:31 GMT

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

Re: Count

Tue, 08 Sep 2015 12:59:10 GMT

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

Re: Count

malini_qlikview — Tue, 08 Sep 2015 13:26:51 GMT

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.

Re: Count

Tue, 08 Sep 2015 14:16:08 GMT

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

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

Re: Count

krishna20 — Tue, 08 Sep 2015 14:17:51 GMT

Hi,

Please find the attached app.

Regards

Krishna

Re: Count

Tue, 08 Sep 2015 14:27:26 GMT

Thanks Krishna,

it is not meeting my requirement. please find the above expected result.

Re: Count

Peter_Cammaert — Tue, 08 Sep 2015 14:37:09 GMT

Very easy to do in load script. It's a pity you don't want that.