count of days dynamic on Month selection

[Karim_Khan]

Hi Team,

     I have the data from 1950 till 2049 now i got the requirment to calculate the noof days in year.

suppose if i click on

1-JAN-1950  --- 1

1-JAN-1960 --- 1

2-JAN-1980  --- 2

3-JAN-1990  --- 3

10-JAN-2040--- 10

.;

;

;

31-JAN-2050  --- 31

am able to populate the above solution but when i go to next month then also it is showing the same result

1-FEB-1950  --- 1

1-FEB-1960 --- 1

2-FEB-1980  --- 2

3-FEB-1990  --- 3

10-FEB-2040--- 10

But requirement is like that if we select FEB month then it should increase in sequential order till the December

they are looking for some thing like

1-FEB-1950  --- 32

2-FEB-1950  --- 33......

28-FEB-2016----59

29-FEB-2016----60

1-MAR-2016 --- 60

2-MAR-2017 --- 61

Reagrds,

KK

kush141087‌sureshqv‌QlikView Forums & Resources‌

[Anonymous]

=Interval(Max(DATEFIELD)-YearStart(Max(DATEFIELD)),'DD')+1

[Karim_Khan]

tnx Bro

[swuehl]

Hi Karim,

didn't my suggested expressions / script lines work for you at all?

Just curious, because it seems to be quite the same as Manuel's.

[Kushal_Chawda]

Hi karim,

I should mark Stefan's answer as correct because he responded first and it seems his answer is exactly the same as Manuel except format function interval

[Karim_Khan]

s it is also working fine thank you

[Karim_Khan]

ya i didn't see that now i changed it

[Anonymous]

Don't worry, I like use functions instead operators. Twice comments are correct to do this.

With Interval you can show too diff in years, months, days, hours, seconds,...

Kind regards!

[swuehl]

Thanks, I was just curious if there was any different in result.