How can I modify the range of x-axis

[Anonymous]

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.

[marcel_olmo]

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]

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]

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]

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