Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
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
Creator
Creator

pls provide your file
Partner
Partner

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?

 

Contributor
Contributor

Hello,

My expected result is:

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

 

Partner
Partner

Do you have a master calendar?

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

Creator III
Creator III

 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

Contributor
Contributor

Hello,

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

Partner
Partner

Maybe providing a sample qvw is better.

Creator
Creator

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

Yes we do have Master Calendar