Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show data in line chart until current date

I have a line chart which has a bunch of data. This chart has one dimension. Dimension is a date range. This chart also contains future data but I only want to display data until current date. So how can I cut off (discard) all data after the current date (today)? I mean I want to only show data in line chart until the current date (included).

3 Replies
trdandamudi
Master II
Master II

It will be great if you can share a sample app, so that we can take a look and suggest..

sunny_talwar

May be like this:


If(DateField <= Today(), yourExpression)


Or you can use set analysis like this:


{<DateField = {"$(='<=' & Date(Today(), 'DateFieldFormatHere'))"}>}

vishsaggi
Champion III
Champion III

Is this what you are looking for just wondering ??

Show only today and older on X-axis of Line chart (exclude future dates)?

Thanks,

V.