topic Re: Exclude total in QlikView

Exclude total

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have used the below condition to exclude a date from the total.

But now the logic changed.Can you please let me know the right query.

Condition:

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))

New Expression:

If(Date>='12/30/2016' , sum(Product$LY),sum(Dollar$LY))

Note: I need to replace the new expression with old expression

For reference above highlighted code is used to remove the total from the below highlighted image.

Thanks..

sunny_talwar — Mon, 05 Dec 2016 18:47:47 GMT

I am not sure I understand what exactly is your required output?

nareshthavidishetty — Mon, 05 Dec 2016 18:53:01 GMT

Hi,

The excluding the value of 1st date from the total.

I need to replace the New expression (If(Date>='12/30/2016' , sum(Product$LY),sum(Dollar$LY))) with

=If(Dimensionality() = 0,

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

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

Thanks..

nareshthavidishetty — Mon, 05 Dec 2016 18:54:58 GMT

nareshthavidishetty Dec 5, 2016 1:53 PM (in response to Sunny T )

Hi,

The excluding the value of 1st date from the total.

I need to replace the old 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))

with (If(Date>='12/30/2016' , sum(Product$LY),sum(Dollar$LY)))

Thanks..