topic Re: Calculation based on month in QlikView

Calculation based on month

Kushal_Chawda — Fri, 25 Jan 2013 07:05:56 GMT

Dear All,

currently I am getting following output as below

mth	mnth	07	08	09
07		1881	-	-
08		-	2013	-
09		-	-	3236

My required output should be

mth	mnth	07	08	09
07		1881	2013	3236
08		-	2013	3236
09		-	-	3236

please find the test application

Re: Calculation based on month

Fri, 25 Jan 2013 07:08:12 GMT

plz. send data file

see the attachement.

in your script write

LOAD id,

mth,

value

FROM

C:\Users\vishwaranjan\Desktop\test00.xlsx

(ooxml, embedded labels, table is Sheet1);

Generic LOAD id, mth,value

Resident a;

then take pivote

where dimension is id

expression is--- 1) mth

2) [7]

3) alt( Below([8]),[8] )

4) alt(Below([9]),[9],Below(Below([9])))

then your output looks like

id	mth	[7]	alt( Below([8]),[8] )	alt(Below([9]),[9],Below(Below([9])))
h1	7	1881	2013	3236
h2	8	-	2013	3236
h3	9	-	-	3236

hope it helps you

Re: Calculation based on month

Kushal_Chawda — Sat, 26 Jan 2013 06:13:56 GMT

Hi Visharanjan,

Thanks for the quick reply.

Can you please help me to calculate total in qlikview as shown in excel.

please find the attched files.

Re: Calculation based on month

Anonymous — Sat, 26 Jan 2013 14:08:20 GMT

Dear Kush,

Please chek the attachment and let me know it's correct or wrong

REGARDS

Re: Calculation based on month

Kushal_Chawda — Sun, 27 Jan 2013 08:01:50 GMT

Dear Basha,

I am having the data as attched in file.

I am not able to get the same ouptput with this data.

Can you help me get the output with this data

Regards,

Kush

Re: Calculation based on month

Anonymous — Sun, 27 Jan 2013 16:48:41 GMT

Dear Kush,

Please check the application and let me know.

Regards

Re: Calculation based on month

Kushal_Chawda — Sun, 27 Jan 2013 18:54:11 GMT

Dear Basha,

Thank you very much for your help.

In attached file I want to achieve something like

I have sales & forecast values. I want to show forecasted values for 1st four month and rest would be the sales.

e.g for No->1 , Jul-Aug-Sep-Oct would be the forecasted

for No->2 , Aug-Sep-Oct-Nov would be the forecasted

for No->3, Sep-Oct-Nov-Dec would be the forecasted

like wise upto the No->12

Can you please help me on this?

This would be the last requirement from my side

Re: Calculation based on month

Anonymous — Sun, 27 Jan 2013 19:10:26 GMT

Dear Kush,

can you please give some clarification on your requiremnet,above conditions i am not understand,

other wise send a excel with your actual data and expectedresult.

Regards