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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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