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.
omkarvamsi
Contributor

Get all previous month data to current date data when date is selected

Hi,

i took year,date as dimensions.

sales as my expression in my Straight table chart.

I am trying to get all previous months sales aggregated upto the selected date in chart.

For Example: when i selected on 15-03-2016 in Date field, I need to get all the previous sales data upto the current date.

It means i need a single record in my chart when i select on 15-03-2016.which should represent in chart as below:

                    year | date | sale

                     2016|15-03-2016|XXXX


I tried using Year to Month(YTD),but it is fetching all the dates upto the selected date.

Please get me answer anyone there.

Thanks in Advance.

Tags (1)
1 Solution

Accepted Solutions

Re: Get all previous month data to current date data when date is selected

I think you can look into the possibility of using The As-Of Table

1 Reply

Re: Get all previous month data to current date data when date is selected

I think you can look into the possibility of using The As-Of Table

Community Browser