Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

smilingjohn
Contributor III

Statc Bar

Hi All,

Please find the attachment of the QVW file.

in this i have bar chart which   which display the values of c d and e ..

but i need to show one more bar as "A" with a static values of 40 ..

how can i achieve this ..

thanks in advance

2 Replies
pooja_prabhu_n
Contributor III

Re: Statc Bar

Hi,

You can join the static value table in the script

Custom:

Directory;

LOAD Alpha,

    Sales

FROM

[..\Users\test\Desktop\List_BOX.xls]

(biff, embedded labels, table is Sheet3$);

Join

LOAD * Inline

[

Alpha, Sales

A,40

];

balabhaskarqlik
Honored Contributor

Re: Statc Bar

Give Inline load like:

ABC:

Load

Col1,Col2,Col3 from abc.csv;

Table:

Load * inline

[

Col1,Col2,Col3

A,B,40

];

It'll Autoconcatenate and create single table.