To display Arrival Trend and Resolved Trend in a single graph in Qlikview

[Rekha]

Hello Experts,

We are having separate tabs in QlikView for Arrival Trends and Resolved Trends. And each tab has its own graph (screenshot below). But we have an urgent requirement to display both the Arrival and Resolved Trends in one graph, under one tab. Can you please suggest how to achieve this ? Earliest response is appreciated. Let me know if you require additional information.

Kind regards,

Rekha

[sugathirajkumar]

pls provide your file

[Arthur_Fong]

Your expected result is:

2 lines [Arrival Trend and Resolved Trend] in a chart?

or 

1 line is displayed.

When user select 'Arrival' button, Arrival Trend will be shown.

When user select 'Resolved' button, Resolved Trend will be shown.

Which is the expected result?

[Rekha]

Hello,

My expected result is:

2 lines [Arrival Trend and Resolved Trend] in a chart.

[Arthur_Fong]

Do you have a master calendar?

I see you are using different dates as dimension in your graph.

[asinha1991]

 if your date field in dimension are same, simply copy expression of one chart and paste it as another expression for merged chart.

It all depends on your data model

[Rekha]

Hello,

I am attaching Sample file with Arrival and Resolved Date for your reference.

[Arthur_Fong]

Maybe providing a sample qvw is better.

[sugathirajkumar]

Filter:
load * inline [
Trends, id
Arrival Trends, 1
Resolved Trends,2
];
exit script;

if(GetFieldSelections(id)='1',expression for Arrival Trends,
if(GetFieldSelections(id)='2',
Expression for Rsolved Trends))

[Rekha]

Yes we do have Master Calendar