topic Report Foramt in QlikView

Report Foramt

upaliwije — Wed, 16 Jul 2014 15:43:46 GMT

Hi Friends

I have some data relating to Sales Reps in table in Oracle. I have attached sample of it in a excel sheet.

I want to load this data into a QV data model and prepare a report as shown in the attached excel sheet. I find it difficult figure out how design the report specially with rows highlighted in Yellow color.

Kindly help with a sample QV documents

Thanks

Re: Report Foramt

engishfaque — Wed, 16 Jul 2014 16:06:50 GMT

Dear Upali,

You can do it by using Pivot Table in QlikView. Follow the following steps and make it just in few minutes.

Step 1:

i. Add Pivot Table and set Dimension and Expression

ii. Chart Properties > Tab Presentation > Checked to Check Box "Show Partial Sums" for Total > Finish

Step 2:

Click on Tab Reports > Edit Reports > Add > Give the name to the report > OK > Edit > Drag and Drop the Pivot Table over the Report.

I hope, you'll enjoy the post.

Kind regards,

Ishfaque Ahmed

Re: Report Foramt

upaliwije — Thu, 17 Jul 2014 02:04:37 GMT

How can I add thd row9s hilighted in yellow in the pivot table

Re: Report Foramt

upaliwije — Thu, 17 Jul 2014 13:29:04 GMT

Can some please reply my question

Thanks

Re: Report Foramt

upaliwije — Thu, 17 Jul 2014 15:37:10 GMT

Mr. Henric

Can you please see my post and give me a solution.

Thanks