How to create Sales Last year to Date

[#1]

Hello all,

In the red markered column in straight table there's no Sales data. I expected in this column sales data based on  startdate 01-12-2014  and enddate 31-12-2014).

Which set analysis / script codes should i use to get the data in the red markered column?

Thank you very much.

Greets,

Rega

[Anonymous]

I think, yes...

Could you share the expression for Sales LY??

[Clever_Anjos]

StartDate and EndDate are variables or fields?

[Anonymous]

Using combination of Date(),Addyears(), or Addmonths() we can achieve same

[HirisH_V7]

Hi,

Check this

https://community.qlik.com/docs/DOC-5103‌

Hope this helps,

Hirish

[#6]

Hi,

Hope this link will help

Sum between two dates

Expression:

Sum( {$<DateField = {“>=$(=Min(StartDate))<=$(=Max(EndDate))”} >} Sales LY)

[#7]

Hello Balray,

This is the currenct expression for Sales LY :

sum({<Year={$(=max(Year)-1)}>}SalesPrice*TransactionQuantity)/1000

[#8]

variables

[#9]

Hi Guys,

none of your answers above has solved the problem. It;s kinda urgent.

Is there anybody who are able to do a screen sharing session today? i have no prefer using tools such as teamviewer/Skype etc.

Waiting for your answer.

Greets,

Rega

[Clever_Anjos]

Since they´re variables you don´t need to worry about Max() and Mins()´s, onlky care about formatting values

This should be enough

sum({<YourDateField={">=$(=Date(StartDate)) <= "$(=Date(EndDate))" "}>}SalesPrice*TransactionQuantity)/1000