calculate row wise last six months data using chart

[khasimvali85]

Hi,

Hope you are doing well!

I am unable to calculate using chart each row wise and last six months data. i have data like below mentioned.

i want to calculate and compare if( avg(Jan       Feb     Mar     Apr    May    Jun    Jul) < Aug    and

                                                        avg(Jan       Feb     Mar     Apr    May    Jun    Jul) < Sep    and

                                                        avg(Jan       Feb     Mar     Apr    May    Jun    Jul) < Oct    and

                                                        avg(Jan       Feb     Mar     Apr    May    Jun    Jul) < Nov    and

                                                        avg(Jan       Feb     Mar     Apr    May    Jun    Jul) < Dec  , 1,0)

(SaleYear)  Jan       Feb     Mar     Apr    May    Jun    Jul    Aug    Sep    Oct    Nov    Dec       

-------------------------------------------------------------------------------------------------------------

(ProdYear)

Jan            0.21     0.10    0.25     0.16    0.01   0.03   0.09  0.01  0.02    0.00   0.01   0.00

Feb             0.11     0.12    0.20     0.11    0.31   0.13   0.29  0.11  0.01    0.02   0.06

Mar             0.16     0.47    0.85     0.18    0.24   0.15   0.21  0.10  0.01    0.01

Apr             0.26     0.31    0.21     0.13    0.15   0.34   0.04  0.01  0.05

May            0.21     0.38    0.25     0.23    0.35   0.30   0.02  0.01

Jun            0.19     0.43    0.21     0.11    0.25   0.10   0.00

Jul              0.11     0.42    0.28     0.24    0.12   0.02

Aug           0.09     0.18    0.06     0.15    0.04

Sep            0.21     0.11    0.21     0.24

Oct             0.31     0.12    0.08

Nov            0.23     0.27

Dec            0.21

how do i achieve this?

Regards,

Khasim.

[Gysbert_Wassenaar]

Please post a small Qlikview document that illustrates the problem.

[khasimvali85]

Hi Gysbert,

Thanks for reply, please check i am attached in excel file with requirement.

Regards,

Khasim.

[Gysbert_Wassenaar]

Is that the source data?

[khasimvali85]

Hi Gysbert,

the given data is source data and the same excel report i wanna implement into Qlikview.

Regards,

Khasim.

[Gysbert_Wassenaar]

See attached qvw.

[khasimvali85]

Hi Gysbert,

Thanks for reply, my actual requirement is not like that

i have already created charts along with data and my requirement is only row wise Calculations of last 6 months data.

Regards,

Khasim.

[settu_periasamy]

Hi Khasim,

Can you post your qvw document?

[khasimvali85]

Hi,

The attached excel file is the my requirement and same implement into Qlikview.

all objects are implemented and only M-Graph not implemented.

in this object i wanna calculate row wise data as mention in excel file.

Regards,

Khasim.

[settu_periasamy]

that is fine. Just want to how did you load your data and about your data model?

May be check the attachment.