Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
harleen_singh
Creator III
Creator III

Which Chart suits this format??

Hello,

        Which chart or table in Qlikview supports Following type of Format??

Jul-06Aug-06Sep-06
Order TypeSalesCostMarginSalesCostMarginSalesCostMargin
Direct$489,329$491,706($2,377)$1,538,408$1,512,155$26,254$1,165,897$1,140,006$25,891
Online$473,388$283,524$189,864$506,192$303,496$202,696$473,943$286,630$187,313
Total$962,717$775,230$187,487$2,044,600$1,815,651$228,949$1,639,840$1,426,636$213,204

thanks

Lavi

1 Solution

Accepted Solutions
Not applicable

Hi ,

   Pivot table will best for this.Add your time dimension and drag into top.

-Jai

View solution in original post

2 Replies
Not applicable

Hi ,

   Pivot table will best for this.Add your time dimension and drag into top.

-Jai

rajtechnocraft
Contributor III
Contributor III

Hi I agree with Prakash, Pivot Table object will be best suited for these kinds of traditional reports. For your sample report you could follow the below steps Step 1: Create a pivot table object with dimension order type and Month Year Step 2 : Cretae concatenated dimension Month & '-' & Year as MonthYear . Step 3: Drag this MonthYear dimension to top row of the pivot table Step 4: Go to Presentation tab and use radiobutton partial sum for the dimension on which you want sub total and grand total .In your case it will be Order Type and MonthYear. Step 5: Use the report formatting options in Layout and style and complete your pivot report. Hope this procedure helps you to build your desired pivot report. Regards Raj.