topic Re: Rolling 12 months in QlikView

Rolling 12 months

fabricius — Wed, 23 Jul 2014 11:15:32 GMT

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

Re: Rolling 12 months

sujeetsingh — Wed, 23 Jul 2014 11:20:02 GMT

Try using accumulation if you are using bar chart.

For doing in chart follow this

How to Manually Accumulate a column ? | Qlik Community

Re: Rolling 12 months

sujeetsingh — Wed, 23 Jul 2014 11:21:05 GMT

Use this thread to rolling in script

Re: Read SQL data by data

Re: Rolling 12 months

fabricius — Thu, 24 Jul 2014 11:33:49 GMT

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)

Result (table)

Re: Rolling 12 months

Mon, 06 Jun 2016 22:06:32 GMT

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