topic Re: Expression help in QlikView

Expression help

Wed, 25 Nov 2020 16:16:04 GMT

Hi expert ,

I have data from 2009 Jan to 2013 Apr.

I want to calculate YTD means if i select 2012 it show brand wise nettotal from 1st jan 2012 to 11th may 2012.

similarly if i select 2011 it shold show net total from 1st jan 2011 to 11th may 2011.

I have attached the sample .qwv file and please help me writing expression.

Best Regards

Tripati

Re: Expression help

sunny_talwar — Wed, 11 May 2016 17:27:17 GMT

May be using this:

Sum({<INVDATE = {"$(='>=' &TimeStamp(SetDateYear(YearStart(Today()), Max(Year))) & '<=' & TimeStamp(SetDateYear(Today(), Max(Year))))"}>}NETTOTAL)

Re: Expression help

Clever_Anjos — Wed, 11 May 2016 17:36:55 GMT

wow, never heard about SetDateYear() function.

Today is a great day for learning stalwar1‌

Re: Expression help

sunny_talwar — Wed, 11 May 2016 17:38:02 GMT

I recently got to learn that from swuehl‌‌ (like may be 2-3 days ago)

Re: Expression help

Clever_Anjos — Wed, 11 May 2016 17:42:06 GMT

swuehl‌ is a Jedi Master with midichlorians level very high

Re: Expression help

Thu, 12 May 2016 07:02:27 GMT

Hi Sunny

Expression is working fine.

Thanks a lot.

Just want to know what is the use of concatenating operator and Setdateyear function.

Best Regards

Tripati