Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kulasekhar
Creator
Creator

Graph

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.

1 Solution

Accepted Solutions
Kushal_Chawda

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

Capture.JPG


View solution in original post

3 Replies
effinty2112
Master
Master

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

1.jpg

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

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

Capture.JPG


Kushal_Chawda

kulasekhar‌ did you get the answer?