topic Graph in QlikView

Graph

kulasekhar — Thu, 13 Jul 2017 12:22:14 GMT

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.

Re: Graph

effinty2112 — Thu, 13 Jul 2017 12:38:26 GMT

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

Re: Graph

Kushal_Chawda — Thu, 13 Jul 2017 12:58:08 GMT

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

Re: Graph

Kushal_Chawda — Tue, 18 Jul 2017 10:28:33 GMT

kulasekhar‌ did you get the answer?