Qlikview - count num of days

[Anonymous]

Hi all,

I want to calculate number of  days between two dates except sunday. I have next table with data:

Like you see I don't have in my table sundays. I want to count how many time Item repeat. I need to get two table.

Fristtable:

Frist table show Item group by Source and number of repeat by date (date by date). The NumOfRep for Item I2 in Source S1 is 2 not 3 because repeat 25-05-2017 and 26-05-2017

Second table:

Second table show Item group by Source and number of repeat by date where date contains today date.

Any idea?

[tresesco]

For second table, should S2 not also be there?

[Anonymous]

No, i need Item that repeat day by day but also contains date today()

[tresesco]

And why not the combination of S1 and I2 ?

[Anonymous]

Because today is 29-05-2017 and S1 I2 repeat 25-05-2017 and 26-05-2017, it also exist 29-05-2017 but not repeat day by day (26-05-2017   29-05-2017)

[tresesco]

OK, I was thinking in line to resolve it in the front-end itself. But now it seems that it has to be done at the back end.

[Anonymous]

Can you help me, give me some idea... I am new in QV

[tresesco]

Idea - create a master calendar with all dates and may be create a flag field for Sundays. You can check this blog for detailed idea : How to populate a sparsely populated field

[Anonymous]

hm, it's not clear to me , I look blog but it's to hard to me