Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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