topic Need to add sales in weekend and show them as it is in WeekDays in QlikView

Need to add sales in weekend and show them as it is in WeekDays

kkkumar82 — Thu, 05 Jul 2018 08:15:11 GMT

Hi Friends,

I have a requirement where I need to show WeekDays sales individually and for the WeekEnd I would like to show the sum of that week

as 'Total Week.

Attaching a sample and qvw .

Re: Need to add weekadd sales

kkkumar82 — Thu, 05 Jul 2018 09:11:07 GMT

stalwar1‌ can you have a look

Re: Need to add weekadd sales

sunny_talwar — Fri, 06 Jul 2018 12:32:28 GMT

Check the attached

Dimension

Name

=If(Match(WeekDay, 'Sat', 'Sun'), Dual('Total Week', WeekEnd), Date(Date))

Expression

If(SubStringCount(Concat(WeekDay, ','), 'Sat') > 0 or SubStringCount(Concat(WeekDay, ','), 'Sun') > 0, Aggr(NODISTINCT Sum(Sale), Name, WeekEnd), Sum(Sale))

Where WeekEnd if created in the script like this

LOAD Name,

Date,

Sale,

WeekDay(Date) as WeekDay,

Date(Floor(WeekEnd(Date, 0, 0))) as WeekEnd

FROM

[Praveen.xlsx]

(ooxml, embedded labels, table is Sheet1);