Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
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.