Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

igor_zhilin
New Contributor III

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
igor_zhilin
New Contributor III

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

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.

1 Reply
igor_zhilin
New Contributor III

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

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.

Community Browser