topic Joining Graphs in QlikView

Joining Graphs

Tue, 19 Nov 2013 11:10:06 GMT

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

The Qlikview is generating this graph:

Someone has an idea how to fix it?

Thanks

Anonymous — Tue, 19 Nov 2013 11:23:27 GMT

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 — Tue, 19 Nov 2013 11:29:38 GMT

use two expressions in one multichart