Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
mohammadkhatimi
Partner
Partner

Values between Start and Finish date

Hi,

My requirement is to capture count of days (week-wise) between Start and Finish date rest will be blank

Below is the output for reference:

Output.PNG

Application and data is attached.

Please do the needful ASAP

Thanks in Advance,

Regards,

Mohammad

29 Replies
mohammadkhatimi
Partner
Partner
Author

okay..Thank you..

Is it possible to show week wise total?

sunny_talwar

Can you elaborate with an example?

mohammadkhatimi
Partner
Partner
Author

PFA of the output sheet..

Also,

I want to create Months if the week falls between two months.

For e.g. Week start is 30th Aug 2015 and weekend is 5th Sep 2015.

So it should show Month as Sep (5 days) as no. of days is more than Aug(2 days).

I want to show trend.

mohammadkhatimi
Partner
Partner
Author

gwassenaar

From backend, its giving me week wise total..

Can u please help me to redefine months..based on Week..

For e.g. Week start is 30th Aug 2015 and weekend is 5th Sep 2015.

So it should show Month as Sep (5 days) as no. of days is more than Aug(2 days).

Regards,

Mohammad

sunny_talwar

Try this

=Sum(Aggr(If(Weekend >= Start and WeekStart <= Finish,

If(Round(Finish - WeekStart) <= 7, Round(Finish - WeekStart) + 1, Round(Weekend - Start)) - If(Round(Finish - WeekStart) <= 7, 0, RangeMax(Above(Round(Weekend - Start)), 0))), [Main Stage], [Sub-Stage], Acti, Start, Finish, WeekStart))

mohammadkhatimi
Partner
Partner
Author

gwassenaar

Please help me in this...

mohammadkhatimi
Partner
Partner
Author

stalwar1

Please help me in this..

sunny_talwar

Help you on what? I did respond to your question above... what is wrong with it?

mohammadkhatimi
Partner
Partner
Author

I want to create Months if the week falls between two months.

For e.g. Week start is 30th Aug 2015 and weekend is 5th Sep 2015.

So it should show Month as Sep (5 days) as no. of days is more than Aug(2 days).

sunny_talwar

Are you just randomly throwing out new requirements or is this linked to the response I gave for the last one? I suggest you to create a new thread for a new incremental requirement....

Thanks,

Sunny