Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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.