Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm looking to create a chart having comparison of number of tickets Assigned vs. Resolved over time (please see below graph, done in excel.)
Number of tickets Resolved = Count of tickets by Last Resolved Date.
Number of tickets Assigned = Count of tickets by Submit Date
X-axis contains:
Could someone please help me with the expressions and the best way to go about it?
Waiting with anticipation for your advice.
Best Regards,
Tony
Guys,
I have finally been able to solve this!
A part of the solution is
Remember to convert the date to integer format (ie. with no fractions) when date is the KEY field for linking two tables. Why don’t my dates work?
Happy Qliking!
Best Regards,
Tony
Hi
I dont think you can do that directly. There are two options that come to mind:
You could hide the legend on each chart and then create another chart and re-arrange (using Shift-Ctrl click/drag) this one so that only the legend shows - so you only have one legend for all four charts
HTH
Jonathan
Hi Tony,
You may use trellis chart for this requirement but it will not give exactly same look and it will give similar look like below chart.
Rgds,
Raju
Hello Jonathan and Raju,
Really appreciate your inputs. Got me thinking on those lines now.
While working on the Trellis chart I'm facing this issue:
How to have two expressions side by side (two bars - count of assigned and count of resolved) as against a single bar?
Best Regards,
Tony
Hi Tony,
Write these two expressions and make it sub type as grouped in style tab.
Regards,
Raju
Hi Raju, Jonathan,
Since I have two different date category (submit date and resolved date) as dimension,this is not working (giving me the same count)
I have just come across this link which throws light on resolving this problem, however this looks a bit high level for me. While i try to achieve as explained in the link, it would be great if you could explain the same thing in a more simple way for me to understand and implement.
http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date
Awaiting with anticipation.
Best Regards,
Tony
Guys,
I have finally been able to solve this!
A part of the solution is
Remember to convert the date to integer format (ie. with no fractions) when date is the KEY field for linking two tables. Why don’t my dates work?
Happy Qliking!
Best Regards,
Tony