topic Show data in line chart until current date in QlikView

Show data in line chart until current date

Wed, 25 Nov 2020 16:16:04 GMT

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).

Re: Show data in line chart until current date

trdandamudi — Tue, 02 Aug 2016 01:45:17 GMT

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

sunny_talwar — Tue, 02 Aug 2016 01:48:29 GMT

May be like this:

If(DateField <= Today(), yourExpression)

Or you can use set analysis like this:

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

Re: Show data in line chart until current date

vishsaggi — Tue, 02 Aug 2016 03:03:45 GMT

Is this what you are looking for just wondering ??

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

Thanks,