topic Re: Excel to Qlikview reports in QlikView

Excel to Qlikview reports

priyarane — Thu, 23 Apr 2015 09:53:48 GMT

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

Thu, 23 Apr 2015 10:02:10 GMT

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

priyarane — Thu, 23 Apr 2015 10:06:56 GMT

Hi Saumil,

GUI, is attached !

Thu, 23 Apr 2015 10:24:44 GMT

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 — Thu, 23 Apr 2015 10:51:56 GMT

Hi Vimlesh,

Thanks for your reply.

If possible can I have sample app with my data.