Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense Line Chart date dimension continous scale grouping does not work

Dear Qlik Fellows.

I need to achieve this:

  • Line chart
  • Date dimension on X axis
  • The whole chart must fit into screen (no scrollbar)
  • Date on X axis should group automatically to month/year etc.

The described behavior is called "Time-aware chart", however, it for some reason works inconsistently. Appreciate your input.

I have this chart already in Document 1, and it works just fine.

dashboard 1 works.png

I paste the same chart into Document 2. I replace the initial date dimension with another date dimension (which in principle has a similar date range 2017-2018). And the X axis is not continuous anymore. And there is no date grouping anymore.

dashboard 2 not works.png

I tagged all date fields with tags $date and $day. Still not working.

Where is the trick?

Thank you,

Igor Zhilin.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Solved quickly, but using a method which I don't completely understand.

I added this line to the script to coerce all fields to be tagged as date:

Tag Fields '*Date*' With $numeric, $integer, $timestamp, $date, $day;

This did the trick.

all works.png

However, I don't get it, why do I need to assign these tags manually to the columns that already come from a database where they have "date" datatype. If you have any clues on Qlik's field tagging, I would really appreciate your input.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Solved quickly, but using a method which I don't completely understand.

I added this line to the script to coerce all fields to be tagged as date:

Tag Fields '*Date*' With $numeric, $integer, $timestamp, $date, $day;

This did the trick.

all works.png

However, I don't get it, why do I need to assign these tags manually to the columns that already come from a database where they have "date" datatype. If you have any clues on Qlik's field tagging, I would really appreciate your input.