Discussion Board for collaboration related to QlikView App Development.
I have a chart. I not have data beyond 3 weeks. However I see dash symbol in scale on x axis. Attaching a screenshot. Any ideas hwo to remove?
Add two dimensions
1) Week Start date
2) The actual Date
Then go to presentation tab and uncheck 'Show Legend' for the second dimension (which is the actual date). This way you will have weekstart date on x-axis and there will be multiple data points if there is more than one data point in that week.
I assume you have changed the color attribute expression for an expression, not for the dimension.
But I forgot that changing the text color of a line chart dimension has some issues:
I played a little with an additional expression and value on axis option, but this does not seem to work nicely, especially with multiple lines.
I also played around with my other suggestion, the continuous axis. Unfortunately, I wasn't able to exactely control the labels.
Then I came back to a non-contiguous axis, but using a calculated dimension instead of the dimension attributes:
=if(Date=Weekstart(Date), Date(Date), Dual('',Date))
On Weekstart, output the date values, on other weekdays, use an empty string text representation.
See attached a demo.
edit: Here is a screenshot of how it looks
This shows data points on week boundaries only. I still dont see week starts on scale and data points by date. So between 10/19 and 9/21 I should see data points at day granularity..
It works as long as you have date_due falling on week start, if no date_due is on week start the x axis scale is completely blanked out which is not correct. I always want to see week starts regardless of date_due coinciding with it or not.