Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

fabricius
New Contributor II

Rolling 12 months

I have just started to use QW and would like someone to help me 😉

I have a date field "WEXAM_CREATED_DATE" that has the format: DD-MM-YYY HH:MM:SS and a number of examinations "count(type)" that occurs that day. (e.g. 124 as a count sum)

I would like to have a 12 months rolling figure that shows the count / sum of "count(type)" for the "WEXAM_CREATED_DATE" and the last 12 months.

I have just started to use QW and would like someone to help me 😉

Søren

4 Replies
sujeetsingh
Honored Contributor III

Re: Rolling 12 months

Try using accumulation if you are using bar chart.

For doing in chart follow this

How to Manually Accumulate a column ? | Qlik Community

sujeetsingh
Honored Contributor III

Re: Rolling 12 months

Use this thread to rolling in script

Re: Read SQL data by data

fabricius
New Contributor II

Re: Rolling 12 months

I am not quite sure if I have explained myself correct.

I have a table as this:

My wish is to have two calculations done

1. Count the number of "Type" per day as Count(Type) and display it as total "Count(Type) in e.g. July 2014.

2. Count the number of "Type" per day as above, BUT as a sum of the last 12 months calculated from e.g. July 2014 (the period: June 2013 till July 2014)

24-07-2014 13-22-58.png

Result (table)

24-07-2014 13-32-35.png

Not applicable

Re: Rolling 12 months

Hi Soren!

Please, could you export to excel this table of your aplication and attach here? Or attach a reduced data QVW file?

Best regards,

Marcello