Text object

[khasimvali85]

Hi,

I have graph table for last one year data and shown in screen short along with excel file.

my requirement is

calculate each row data for last six months average total for all years.

please check in excel format and screen short.

anyone help for my achievement and waiting for reply.

Regards,

Khasim.

[kaushiknsolanki]

Hi,

Is the excel is your data, which you are loading in QlikView?

Regards,

Kaushik Solanki

[khasimvali85]

Hi Kaushik,

Thanks for reply, the given data is my qlikview data .

[avinashelite]

check this documents ...

Rolling 3, 6 and 12 months calculation | Qlik Community

Calculating rolling n-period totals, averages or other aggregations

[khasimvali85]

Hi Avinash,

Thanks for suggest but my requirement is not like that.

please see the excel file you will understand.

[khasimvali85]

Hi Avinash,

Any suggestion for my requirement?

its urgent requirement anyone give idea about my given requirement.

Regards,

Khasim.