topic Re: how can we write expression for current year sales(chart should change dynmicaaly for next year? in QlikView

how can we write expression for current year sales(chart should change dynmicaaly for next year?

Wed, 25 Nov 2020 16:16:04 GMT

how can we write expression for current year sales(chart should change dynamically for next year?

Re: how can we write expression for current year sales(chart should change dynmicaaly for next year?

Anil_Babu_Samineni — Tue, 07 Mar 2017 12:49:46 GMT

Dynamically for next year means

Sum({<Year = {'$(=Max(Year))'}>}Sales) // It will give 2017 data sales if you have till 2017 data. In future, If you are adding or updating for next year it will return 2018 data point of sales

Sum({<Year = {'$(=AddYears(Max(Year),1))'}>}Sales)

Re: how can we write expression for current year sales(chart should change dynmicaaly for next year?

sunny_talwar — Tue, 07 Mar 2017 12:52:28 GMT

May be this

Sum({<Year = {"$(=Year(Today()))"}>} Sales)

Re: how can we write expression for current year sales(chart should change dynmicaaly for next year?

Tue, 07 Mar 2017 14:03:47 GMT

Sum({<Year = {'$(=Max(Year))'}>}Sales) //// it shows the 2018 year.I didn't get 2017

if i write this expression sum({$<Year={$(=max(Year)-1)}>}Sales) //// i get 2017 year,what is the reason. plz tell me

Gopichand

Re: how can we write expression for current year sales(chart should change dynmicaaly for next year?

Anil_Babu_Samineni — Tue, 07 Mar 2017 14:05:25 GMT

May be you have forecast data for 2018 too.