Skip to main content
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How can I modify the range of x-axis

Hi All,

I am new to qlik sense and need your help. Can you please suggest how can I modify the range of x-axis. Now here as shown in below screen shot the dates are shown in x-axis. Now I want to see the data for the latest date.

chart.PNG

4 Replies
marcel_olmo
Partner Ambassador

I'm afraid it can't be done in Qlik Sense,

Here's more details :

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Visualizations/LineChart/line-char...

Regards, Marcel.

mikaelsc
Specialist

sure it is possible:

use set analysis to "limit" measure values to certain values of dimensions !

Set Analysis: syntaxes, examples‌

so something like sum({<Date={"$(=max(Date))"}>}Sales) for only the latest date value

or more fun with sum({<Date={">=$(=max(Date))-42"}>}Sales) to get only measure values for dates >= max date - 42

Anonymous
Not applicable
Author

Thanks for your response but can you please guide me where I have to configure set analysis to define dates for which I want data.

rahulgoyal1287
Contributor III

Hi, by looking into this it can be spotted that single date is coming multiple times on X-Axis which is due to timestamp values. You can use Dayname(Dimension_name) at the script level to remove the timestamp... then you can have a  single value for each day.

coming back to your question, you can define the variable at script level or at report level by going to variable box which is available at extreme left bottom on the screen..

You can define the variable to get the current date

& which you can pass an input to the expression as suggested by Mikael.

Hope this helps. Cheers

Rahul