Graph

[kulasekhar]

Hi All,

I want to show graph in excel. I am trying QVW SpecificationNumber showing like 881263 06 02 ,881099 05 01 .  I want show SpecificationNumber 1 to 100 , 100 to 200 like graph in excel. Sort by Y-value Descending order. please give idea wich graph is better.

I am loding the data from QVD only.

I will share with you excel file , QVW file and QVD file .

Thanks

Sekhar.

[effinty2112]

Hi Sekhar,

Try:

Data:

LOAD

RecNo() as [Number of Specifications],

SpecificationNumber,

     QtySold

FROM

[Report - Copy.xlsx]

(ooxml, embedded labels, table is [Sales Per Specification]);

then

There is a trick required to show the full range of the dimension. Make the chart as a bar chart. In presentation click on Show all bars. Now change the chart type to line.

Cheers

Andrew

[Kushal_Chawda · Accepted solution]

see this

Data:

LOAD ITEM_NUMBER_LOCAL,

    PRODUCT,

    RecNo() as Rec,

    SPECIFICATION,

    DRAWING_NUMBER_LOCAL,

    YEAR,

    QTY_SOLD

FROM

[SECONDCUT.qvd]

(qvd);

Temp:

LOAD  SPECIFICATION,

      sum(QTY_SOLD) as QTY_SOLD_SPEC

Resident Data

Group by SPECIFICATION

;

Drop table Temp;

Sort:

LOAD SPECIFICATION,

    QTY_SOLD_SPEC,

    AutoNumber(SPECIFICATION) as SPECIFICATION_SORT

Resident Temp

Order by QTY_SOLD_SPEC desc;

Dimension:

SPECIFICATION_SORT

Expression:

=sum(QTY_SOLD_SPEC)

Go to Axis tab and make the X axis continuous

[Kushal_Chawda]

kulasekhar‌ did you get the answer?