This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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:
Application and data is attached.
Please do the needful ASAP
Thanks in Advance,
Is it possible to show week wise total?
Can you elaborate with an example?
PFA of the output sheet..
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.
From backend, its giving me week wise total..
Can u please help me to redefine months..based on Week..
=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))
Please help me in this...
Please help me in this..
Help you on what? I did respond to your question above... what is wrong with it?
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....