Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
pretty new to Qlik and trying to get some of my wishes in. See the graph below...
it shows in grey a specific KPI (eg. average price) for wk 39 - 45
in pink it shows the average of the KPI during the completed quarters.
Would something like this be possible in Qlik?
You can use two garphs and then anjust them to look as the one in the image.
is it possible to link y axis range of the quarterly graph to the weekly graph?
The weekly values can fluctuate pretty much.... and I would like those to determine the y range.
To sync up the axis range you need to use Static Max in Axes tab.
RangeMax(Max(Aggr(Avg(Price), Quarter)), Max(Aggr(Avg(Price), Week)))
in both the charts
Couple of methods:
Create a number of expressions in chart, 1 for each column you want. The exoression would include the logic to include only the date applicable to that column. Use an iF or Set Analysis
Or
Create a field in script. We call it something like Dim_Date_QtrAnd6Weeks. Two fields. One to display as x axis, other links to the date in your fact table. Create it with Qtr1 and every date in quarter1. Repeat for each column. Can have same date in two columns, qlikview won't mind. In chart use that as dimension, make sure to sort on load order though.