topic Re: Do not include the last day's data in QlikView

Do not include the last day's data

Fri, 19 Sep 2014 08:59:44 GMT

How can I amend my expression so that the last day of the data set is NOT included in the chart?

SUM({$<CalendarDayName-={'Sat','Sun'}>}DaySummary.Users)

tresB — Fri, 19 Sep 2014 09:02:52 GMT

May be like:

SUM({$<CalendarDate-={"$(=Max(CalendarDate))"}>}DaySummary.Users)

PrashantSangle — Fri, 19 Sep 2014 09:09:52 GMT

Hi,

Can you explain with sample data?

Regards

Fri, 19 Sep 2014 09:17:12 GMT

try this

if(not wildmatch(CalendarDayName,'Sat','Sun'),DaySummary.Users)

jyothish8807 — Fri, 19 Sep 2014 09:29:09 GMT

In the below script it will exclude max(date) and will take all the other dates.

SUM({$<CalendarDate-={"$(=Max(CalendarDate))"}>}DaySummary.Users)

Regards

PrashantSangle — Fri, 19 Sep 2014 09:50:15 GMT

Hi,

I understand what Tresesco Suggest.

But I am Confused with Alex requirement, Becuase below expression was tried by Alex made me confused

SUM({$<CalendarDayName-={'Sat','Sun'}>}DaySummary.Users)

that what he actually trying to acheive, that either he want data upto last days or He is trying to exclude Week end data.

That why I asked Alex to explain with some example.

But he got correct solution, So I understand what was he is looking for

Regards,

jyothish8807 — Fri, 19 Sep 2014 09:56:52 GMT

Sorry bro