Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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
Honored Contributor II

Re: Show data in line chart until current date

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

Re: Show data in line chart until current date

May be like this:


If(DateField <= Today(), yourExpression)


Or you can use set analysis like this:


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

vishsaggi
Esteemed Contributor III

Re: Show data in line chart until current date

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.