Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
offjunior
Creator
Creator

Rolling Six Months

Good morning friends!

I'm trying to make a kind of rolling, where I always do a sum of the last six months, but grouping by other fields. However I do not know how to add up the last 6 values ​​do not follow. In practice is the following, I have a column called "date" (dd / mm / yyyy) which is one of the dimensions is another dimension column "Site Name", the other columns are expressions, all this in a Pivot Table . I wanted to add the last six months for each "Name Location" specific. Perhaps the image can illustrate what i need.

Attached hereto, an image, a QVD files with data and application.

Thank you all!@

1 Solution

Accepted Solutions
offjunior
Creator
Creator

Hello friends!

I had no answer here in the community, however I got the solution to my problem, where only one is needed to do in my script that made the reading of my table by adding and grouping the values ​​of 6 in 6 months. If anyone needs the solution, I am available.

Thank you!

View solution in original post

8 Replies
offjunior
Creator
Creator

Hello friends!

I had no answer here in the community, however I got the solution to my problem, where only one is needed to do in my script that made the reading of my table by adding and grouping the values ​​of 6 in 6 months. If anyone needs the solution, I am available.

Thank you!

View solution in original post

mphekin12
Specialist
Specialist

Junior Junior,

I am facing a similar challenge where I am trying to get a sum of the last 12 months of sales based on Divisions.  Can you post your solution as it may be helpful!

Thank you.

offjunior
Creator
Creator

Good afternoon friend!

Extracts a small part of my application to send you an example that is more concise easier for your understanding ... I tried to put some comments in English, in the script to help you ...

Hope this will help you with your problem.

Big Hug!

mphekin12
Specialist
Specialist

Thank you!

punitpopli
Creator III
Creator III

Hi offjunior

I am facing similar kind of problem but for weeks in my project.

Could you please share the solution which you have implemented in your project  in English please?

offjunior
Creator
Creator

Good morning!

In the previous post their exists a file with my solution.

See if this meets you.

Thank you.

punitpopli
Creator III
Creator III

Hi offjunior,

The text file you have added is not in English.

Could you please add the sample script file which you have implemented in English?

Thanks in advance,

Punit

offjunior
Creator
Creator

Friend, some comments are already in English out, what it is not, please use Google Translate. For better understanding, paste the text into your script editor.