Exclude total for one date

[nareshthavidishetty]

Hi ,

We were showing the business starts from every last day of month end to till date and now we were doing normal total.

But the businesses want to exclude the month end and include the total starts from 1st of month.

Below is the output qlikview which need to exclude the first row value in the total.

Dimension: =if(Date>='$(vMonthEnd)' and Date <='$(vCurrMonth)',Date)

where vMonthEnd  = (monthend(addmonths(Date(today(),'MM/DD/YYYY'),-1)))

      vCurrMonth  = =(MonthEnd(today()))

Expression :  Sum(Product$)

Chart Type :  Straight Table

So the final total should show as $21,600,243 - $3,841,198 = $ 17,7590,45(Final Total $)

Thanks..

[nareshthavidishetty]

Hi ,

This would remove the 7/31/2016 but i need to show data from 7/31/2016 to till date but in total i need to exclude only the 7/31/2016 count .

Thanks..

[sunny_talwar]

This?

[sunny_talwar · Accepted solution]

Dimension:

Date

=pick(match(WeekDay(Date),'Mon','Tue','Wed','Thu','Fri','Sat','Sun'),'Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday')

Expression:

=If(Dimensionality() = 0,

Sum({<Date = {"$(='>=' & Date(MonthStart(Today())) & '<=' &  Date(MonthEnd(Today())))"}>}Product$TY),

Sum({<Date = {"$(='>=' & Date(MonthStart(Today())-1) & '<=' &  Date(MonthEnd(Today())))"}>}Product$TY))

[nareshthavidishetty]

Thanks! a lot Sunny it's working..Amazing..

Thanks..