Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Rekha
New Contributor

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

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.

clipboard_image_1.png

clipboard_image_0.png

clipboard_image_0.png

Kind regards,

Rekha

15 Replies
sugathirajkumar
Contributor

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

pls provide your file
Partner
Partner

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

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
New Contributor

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

Hello,

My expected result is:

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

 

Partner
Partner

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

Do you have a master calendar?

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

asinha1991
Contributor III

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

 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
New Contributor

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

Hello,

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

Partner
Partner

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

Maybe providing a sample qvw is better.

sugathirajkumar
Contributor

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

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
New Contributor

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

Yes we do have Master Calendar