topic Re: Problem with days in weekstart and weekend in QlikView

Problem with days in weekstart and weekend

fkeuroglian — Tue, 29 Apr 2014 13:03:58 GMT

Hi, i have a problem that i cant resolve

I have day, month, year that is create based on the date(day/month/year)

i want to count some particular things using weekstart (date selected) and weekend(date selected)

when the date selected is the field date(28/08/2013) the result is ok 4467

but when i do the selection in parts(first year, then month and then day) the result is 0 in the same date

the problems appears when i select the day.. when i select year and month is ok

i send attach a simple qvw with this case

please let me know if you can help me!

thank you a lot

Fernando

Re: Problem with days in weekstart and weekend

tresB — Tue, 29 Apr 2014 13:35:09 GMT

You should bypass day, year, month selection using set analysis like:

=count({<Day=,Month=,Year=,SolDateValeReal={">=$(=weekstart(max(makedate(Year,Month,Day)),-1))<=$(=weekend(max(makedate(Year,Month,Day)),-1))"}>} distinct SolNroVale)

Re: Problem with days in weekstart and weekend

fkeuroglian — Tue, 29 Apr 2014 15:15:33 GMT

Thank you a lot!