Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Duplicate Date on X-Axis Line Graph

I have a line graph with a dimension "cboDate", tied into a measure of "Index Number".... What I am trying to do is get the line graph to show the count of how many individual Index Numbers for each single date.


When just adding "cboDate" as Dim and "Index Number" as measure I get a X-Axis that lists duplicate same dates but I want it to add all the Index numbers that took place on each day only. Any ideas? Thanks in advance.

1 Solution

Accepted Solutions
stigchel
Partner
Partner

A date is a so called dual field with a text representation and a number presentation. Your text presentation may be set to show a single day, but the number representation probably includes the time and this is why QV is treating this as different values.

You could use a calculated dimension like

=Date(Floor(cboDate),'DD-MM-YYYY')

performance wise it is better to create this field in the load script

View solution in original post

6 Replies
shree909
Partner
Partner

Try this

  1. Try to convert  cboDate in the script to proper date format with distinct .
  2. If your creating any master calendar from the cboDate , try to take distinct and create a calendar.

If possible please share a sample app ...


Not applicable
Author

Qlik.jpg

As you can see my Y-Axis is a count of "Index Numbers" that are logged throughout the day... However, each index number is attached to a date. I do not want the same date repeated on the X-Axis.

shree909
Partner
Partner

can you share a sample data to look into it..

Not applicable
Author

I am not authorized to.

stigchel
Partner
Partner

A date is a so called dual field with a text representation and a number presentation. Your text presentation may be set to show a single day, but the number representation probably includes the time and this is why QV is treating this as different values.

You could use a calculated dimension like

=Date(Floor(cboDate),'DD-MM-YYYY')

performance wise it is better to create this field in the load script

View solution in original post

Not applicable
Author

Perfect. Thank-You!