Calculation based on month

[Kushal_Chawda]

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

[#2]

hi

plz. send data file

see the attachement.

in your script write

a:

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

[Kushal_Chawda]

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.

[Anonymous]

Dear Kush,

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

REGARDS

[Kushal_Chawda]

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

[Anonymous]

Dear Kush,

    Please check the application and let me know.

Regards

[Kushal_Chawda]

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

[Anonymous]

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