topic Re: Help please. selected date -1 in set analysis. in QlikView

Help please. selected date -1 in set analysis.

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to build a set analysis expression which returns the result based on the date previous to the current selection.

My Date field is [Date] , formatted (18/07/2016) and my current expression is:

sum({<[Date]={'$(=Max([Date])-1))'},[Channel]={"Agg"},[Product]={"Motor"}>}[Quoted])

I'm guessing that not only is my syntax incorrect but also the result is a numeric value of the date which need formatting?

Any help would be greatly appreciated.

Many Thanks

sunny_talwar — Mon, 18 Jul 2016 10:19:11 GMT

Try this:

Sum({<[Date]={"$(=Date(Max([Date])-1, 'DD/MM/YYYY'))"}, [Channel]={"Agg"}, [Product]={"Motor"}>}[Quoted])

Update: Changes I have made are in red above

nizamsha — Mon, 18 Jul 2016 10:23:42 GMT

in your expression one extra closing bracket is there i corrected it check this one

sum({<[Date]={"$(=Date( Max([Date])-1)"},[Channel]={"Agg"},[Product]={"Motor"}>}[Quoted])

Mon, 18 Jul 2016 10:44:57 GMT

Perfect.

Thank you.