topic Re: calculate row wise last six months data using chart in QlikView

calculate row wise last six months data using chart

khasimvali85 — Mon, 04 Apr 2016 10:55:01 GMT

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.

Re: calculate row wise last six months data using chart

Gysbert_Wassenaar — Mon, 04 Apr 2016 11:31:51 GMT

Please post a small Qlikview document that illustrates the problem.

Re: calculate row wise last six months data using chart

khasimvali85 — Mon, 04 Apr 2016 12:10:50 GMT

Hi Gysbert,

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

Regards,

Khasim.

Re: calculate row wise last six months data using chart

Gysbert_Wassenaar — Mon, 04 Apr 2016 12:16:10 GMT

Is that the source data?

Re: calculate row wise last six months data using chart

khasimvali85 — Mon, 04 Apr 2016 12:20:44 GMT

Hi Gysbert,

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

Regards,

Khasim.

Re: calculate row wise last six months data using chart

Gysbert_Wassenaar — Mon, 04 Apr 2016 13:03:04 GMT

See attached qvw.

Re: calculate row wise last six months data using chart

khasimvali85 — Tue, 05 Apr 2016 04:52:45 GMT

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.

Re: calculate row wise last six months data using chart

settu_periasamy — Tue, 05 Apr 2016 05:15:05 GMT

Hi Khasim,

Can you post your qvw document?

Re: calculate row wise last six months data using chart

khasimvali85 — Tue, 05 Apr 2016 09:19:48 GMT

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.

Re: calculate row wise last six months data using chart

settu_periasamy — Tue, 05 Apr 2016 10:23:23 GMT

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

May be check the attachment.

Re: calculate row wise last six months data using chart

khasimvali85 — Tue, 05 Apr 2016 11:58:13 GMT

Hi,

Thanks for reply, i am attached my data modelling file above.

Re: calculate row wise last six months data using chart

settu_periasamy — Tue, 05 Apr 2016 13:36:41 GMT

May be check the attachment in the above thread..

Re: calculate row wise last six months data using chart

khasimvali85 — Wed, 06 Apr 2016 06:00:08 GMT

Hi,

Thanks for response, my requirement is not like that

1, the avg(jan to july data) compare with aug, sep, oct, nov, dec months this means compare with last five each months data compare like avg(jan to july data) < Aug OR avg(jan to july data) < Sep OR avg(jan to july data) < Oct OR avg(jan to july data) < Nov OR avg(jan to july data) < Dec

2, I want this values use in another text object shows the

value is = 0 green symbol

value is > 1 red symbol

value is <1 and >0 yellow symbol.

Re: calculate row wise last six months data using chart

khasimvali85 — Sat, 09 Apr 2016 07:16:46 GMT

Hi,

Please provide the solution for above query?

Re: calculate row wise last six months data using chart

khasimvali85 — Fri, 27 May 2016 11:43:56 GMT

Hi Community,

Please provide the solution for above post