Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
well if its an adhoc request do this
Table:
Load Date(Created,'dd/mm/yyyy') as DateKey,//use the format you want in chart
'Created' as DateType,
1 as cnt
from excel;
Load Date(Resolved,'dd/mm/yyyy') as DateKey,//use the format you want in chart, add more dimension like week, //month etc, if you want to have drill down
'Resolved' as DateType,
1 as cnt
from excel;
in your chart add date fields as dimension and two expression sum({<DateType={'Created'}>}cnt) and sum({<DateType={'Resolved'}>}cnt)
Thank you for the script. Where exactly do I have to use this - in Master Calendar ?
well I assumed you have no model, can you do ctrl+T and paste the image?
your data set is not linked to master calendar
assuming that arrivaldate, resolveddate and calendar date are in same format and case_id_ is the unique key
add this as new code
Date_link:
Load ARRIVAL_DATE as CalendarDate,
'Arrival' as DateType,
CASE_ID_
Resident Sephora;
Load RESOLVED_DATE as CalendarDate,
'Resolved' as DateType,
CASE_ID_
Resident Sephora;
in front end create a group dimension using fields from Calendar table.
Create a line chart with new group dimension as dimension
add two expression
count({<DateType={'Arrival'}>}CASE_ID_)
count({<DateType={'Resolved'}>}CASE_ID_)
Rekha, did Anand's latest post get you what you needed? If so, please do not forget to come back and use the Accept as Solution button to give him credit and let others know that solved things. If you are still struggling, please provide an update, and you may want to attach a sample app as well this time in order for folks to see everything, as it should be much easier for them to provide a working example at that point.
There is one thing I am going to include here, a design blog post that may be of some use:
https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527
https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Time-Table/ba-p/1469392
https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578
Hopefully those may be of some further help if you are still struggling with things.
Regards,
Brett