Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Excel to Qlikview reports

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


4 Replies
Not applicable

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

priyarane
Specialist
Specialist
Author

Hi Saumil,

GUI, is attached !

Not applicable

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
Specialist
Specialist
Author


Hi Vimlesh,

Thanks for your reply.

If possible can I have sample app with my data.