Excel to Qlikview reports

[priyarane]

Hi Experts,

I have excel sheet as requirement to build the report. There are many calculations part in that I tried to modified but fialed.

Can some one please help me to build the report.

Note:

1. We can modify excel sheet

2. All grey color columns has formulas(example attached)

3. Need the report like

Item  ---- Sub item ---- subItem1(if neccessary)----- As of Date ----- P Q1------ PQ2.......till PQ9

[#2]

Hi can you please provide some GUI related screen so that i can figure out the problem.

[priyarane]

Hi Saumil,

GUI, is attached !

[#4]

Dear Priya,

this is balance sheet chart so you need to do calculation in chart with name.

such as

Cash and balances due from depository institutions		100
Federal funds sold and securities purchased under agreements to resell		200
Securities (excluding securitizations): Held-to-maturity		300
Securities (excluding securitizations): Available-for-sale		400
subtotal                                                                                 = column(1)+cloumn(2) +cloumn(3)+column(4)

like this.

Regards

Vimlesh

[priyarane]

Hi Vimlesh,

Thanks for your reply.

If possible can I have sample app with my data.