Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

warrentk80
New Contributor III

graphic Mixed

Goodmorning everyone

I need to build a mixed chart with a bar and a linear representation.

the size of the measures on which I make the calculations are different.


someone would know tell me how to do?

send attached files database in excel, dashboard example of what I did and picture of what I want.

Thank you

Andrea

4 Replies
warrentk80
New Contributor III

Re: graphic Mixed

sorry attachments

Re: graphic Mixed

Your two tables are not linked with each other.. How you want to show their fields in one chart?

Re: graphic Mixed

May be this:

Script:

SET LongMonthNames='Gennaio;Febbraio;Marzo;Aprile;Maggio;Giugno;Luglio;Agosto;Settembre;Ottobre;Novembre;Dicembre';

LOAD Month(Serie) as Month,

    Vendite

FROM

[esempio.xlsx]

(ooxml, embedded labels, table is Lines);

LOAD Month(Date#(Mese, 'MMMM')) as Month,

    Acquisti

FROM

[esempio.xlsx]

(ooxml, embedded labels, table is Istogramma);


Capture.PNG

warrentk80
New Contributor III

Re: graphic Mixed

I modified the basic dates for the dimension in common (codicemese)
in the bar graph does not show all the months, but only those which have been made both sales and purchases.

Thank you

Andrea

attached example

Community Browser