topic Re: Statc Bar in QlikView

Statc Bar

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

pooja_prabhu_n — Fri, 17 Aug 2018 09:54:16 GMT

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

];

BalaBhaskar_Qlik — Fri, 17 Aug 2018 12:59:56 GMT

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.