Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Joining Graphs

Hello,

I'm having a problem when I try to join two graphs.

I'm using as dimension in A: month_created and in B: month_resolved,

And the same expression in both: count(qtd)

A                                                                                          B

image001.png

The Qlikview is generating this graph:

Untitled.png

Someone has an idea how to fix it?

Thanks

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

do as :

1. Rename the two diffrent months that is month_created and month_resolved as month

Table1:

month_resolved as Month,

qtd as qtd_resolved

table2:

month_created as Month,

qtd as qtd_created,

join both two tables to common calendar hope you know it how to create a calendar and connect individula tables by Date field.

then add the Month field to graph and use two diffrent expression count(qtd_resolved) and count(qtd_created).

regards,

anant

View solution in original post

2 Replies
Anonymous
Not applicable
Author

do as :

1. Rename the two diffrent months that is month_created and month_resolved as month

Table1:

month_resolved as Month,

qtd as qtd_resolved

table2:

month_created as Month,

qtd as qtd_created,

join both two tables to common calendar hope you know it how to create a calendar and connect individula tables by Date field.

then add the Month field to graph and use two diffrent expression count(qtd_resolved) and count(qtd_created).

regards,

anant

sujeetsingh
Master III
Master III

use two expressions in one multichart