Set analysis

[#1]

Hi All, nedd help, i have a table :

AbonementID	AbonementEndDate
1	2013.03.03
2	2013.03.04
3	2013.03.06
4	2013.02.04
5	2013.02.05
6	2013.04.06
7	2013.02.07
8	2013.03.08
9	2013.03.09
10	2013.04.10
11	2013.04.11
12	2013.06.12

i need 2 set analysis, one: i need count all active abonements at the start of month, for examp: at 1 of march i have 9 active abonements,

second set analysis: i need count all active adonements at the month  end(march 31), expecting result =3

please help

[MK_QSL · Accepted solution]

1)

COUNT({<AbonementEndDate = {'$(=MonthStart(Today()))'}>}AbonementID)

2)

COUNT({<AbonementEndDate = {'$(=MonthEnd(Today()))'}>}AbonementID)

Update : Please check enclosed file of similar functionality

[#3]

Thans for fast replay, correct my if i wrong, for sum its working great, but i think for count is working wrong.. its counts only those abonements ho have abonements end date at monthstart and monthend.

[MK_QSL]

What is your requirement?

What ID you want to count ? i.e. Only at the End of Month or Start of Month or something else?

May be I misunderstood your question.

[#5]

i need count abonement id,my requirement is: 1 set analysis, count all active abonements when we have a monthstart, by my table result would be:

AbonementID	AbonementEndDate
1	2014.03.03
2	2014.03.04
3	2014.03.06
6	2014.04.06
8	2014.03.08
9	2014.03.09
10	2014.04.10
11	2014.04.11
12	2014.06.12

second set analysis count all active abonements when we have a monthend, result:

AbonementID	AbonementEndDate
6	2014.04.06
10	2014.04.10
11	2014.04.11
12	2014.06.12

in my first post  the year is wrong, should be 2014, i think that is you mislead, sorry

[MK_QSL]

It is difficult for anyone to give you result without knowing your actual data.

Can you post your sample apps or sample data with desired output.

This will be easiest way to give you straight forward answer..

[#7]

i found solution, little modified yours set analysis  and its works:

COUNT({<Abonement.End = {">=$(=MonthStart(Today()))"}>}distinct SabID)

and

COUNT({<Abonement.End = {">=$(=MonthEnd(Today()))"}>}distinct SabID)

with my english i cant clearly explaint what i waint i think...sory and thanks for help

[MK_QSL]

Oh... you want to count from MonthStart and From MonthEnd...

As far as you got your answer, I am happy.

English is not a barrier to learn QlikView... Enjoy....

[#9]

one more question, is it posible to remove today() funtion from set analysis? if i want to analyse date in the past, for example, 2013 year and december month?

[MK_QSL]

You can remove Today() and make more dynamic like below

Considering that you have List BOX with Field Date...

You can use below ...

=SUM({<Date = {'>=$(=MonthStart(Max(Date)))'}>}Sales)