Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for
Did you mean:
Creator III

## Which Chart suits this format??

Hello,

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

 Jul-06 Aug-06 Sep-06 Order Type Sales Cost Margin Sales Cost Margin Sales Cost Margin 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

2 Replies
Not applicable

Hi ,

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

-Jai

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.

Community Browser