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

Calculate Year to date, month to date sales

Dear all,

I have an expression in a cart to display year to date sales, previous year , as -

sum({<xYear={$(=max(xYear)-1)}>} Store_TotalSales)/1000

I would like to display year to date, month to date sales, from previous year.

I have fields xMonth and xDay also, but don't know how to use them in this expression since im new to QlikView.

Please help.

Thanks

2 Replies
MVP
MVP

Re: Calculate Year to date, month to date sales

Not applicable

Re: Calculate Year to date, month to date sales

Thanks Manish. I will go through the document and get back in case of further questions.

Community Browser