Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
warrentk80
Creator
Creator

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
Creator
Creator
Author

sorry attachments

MK_QSL
MVP
MVP

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

sunny_talwar

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
Creator
Creator
Author

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