topic Re: Help please in QlikView

Help please

Wed, 18 Mar 2015 12:55:41 GMT

I@m collecting data direct from a spreadsheet sheet with several years of data entered with individual day lines

I want to show the last 6 months average value by consecutive month

I.e.

I have the Dimension “Downtime date” a daily date reference

I have a second dimension “log type" which separates the items into 4 categories to show by price

( I also have available “Downtime Month” or “Downtime year”

I have an expression AVG “invoice price”

Could you help me with the modifications to the expressions to pick up the "last" 6 months info as I only seem to be able to pick an individual years month and not run across 2 years

thanks

Re: Help please

Gysbert_Wassenaar — Wed, 18 Mar 2015 13:17:54 GMT

Perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations

Re: Help please

Fri, 24 Jul 2015 02:59:38 GMT

Hi,

Hope it will help u to complete u r task,

use straight table for this

dimensions : Downtime date,log type

In Expressions tab:

under Accumulation-> click on check box Accumulation -.> set steps back to 6

Expression : sum({<Downtime year={2015}>} invoice price)

Hope it will helps u.

Thanks and regards

Balaji.k

Re: Help please

Fri, 24 Jul 2015 05:43:21 GMT

* INLINE [

    college,name, score

   ?a, 1, 50

   ?a, 2, 60

    ?b, 3, 70

   b, 4, 30

   b, 5, 30

   b, 6, 30



]

where Left(ltrim(college),1)='?';