Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

how to use next to function and previous function?

hi guys ,

i wrote function like this sum({$1}sales) ,this function display all year sales but actually this function display previous year sales. i do not know how  write previous year sales function.please tell me out  how to write function.

Regards:

madhu

9 Replies

Re: how to use next to function and previous function?

sum({$ <year={'<$(=year(today()))'}>} sales)

MVP
MVP

Re: how to use next to function and previous function?

SUM({$<Year = {'$(=Max(Year)-1)'}>}Sales)

Not applicable

Re: how to use next to function and previous function?

thanks alessandro

Not applicable

Re: how to use next to function and previous function?

Thanks manish

MVP
MVP

Re: how to use next to function and previous function?

If you have got your answer, please close the thread by selection appropriate answer.

Not applicable

Re: how to use next to function and previous function?

how to write forward function?

Not applicable

Re: how to use next to function and previous function?

how to write forward function

MVP
MVP

Re: how to use next to function and previous function?

There is no Forward Function...

anbu1984
Honored Contributor III

Re: how to use next to function and previous function?

sum({$ <year={'<$(=year(today())+1)'}>} sales)

Community Browser