Looking for the Min of vCurrentWeek - Qlik Community

Report Inappropriate Content · ‎2012-09-05

Hello,

I need assistance to get the minumum of the current week. This expression isn't working does anyone know why?

Sum ({<DaysFilled.Date={"$(=min(vCurrentWeek))"}>}DaysFilled.Days)

Thank you in advance,

OneputtGirl

sebastiandperei · ‎2012-09-05

Hi Girl,

What kind of content has vCurrentWeek? is a field or a variable? You are suming, but you need the min value...

I can't understand your question. Could you send a reduced copy and explain a little better your question? (sorry, my english is not good)

Report Inappropriate Content · ‎2012-09-06

Ok, I now see that my logic is wrong. vCurrentWeek is the 36 week of the year. The DaysFilled.Date is a data format of mm/dd/yyyy. Do you have logic that will get me the minumum DaysFilled.Date of this the Current Week. I would also like the max of the Current Week also. Thank you for anyones assistance.

sebastiandperei · ‎2012-09-07

Could you send a reduced copy of qvw file ?