topic Re: Display future dates in chart in QlikView

Display future dates in chart

Wed, 08 Jun 2016 08:29:49 GMT

Hi,

I need to create a chart where data is displayed only for future dates

i.e. Dates> today()

How do I write an expression to achieve this?

I tried something like Date > Date(today(),'YYYY-MM-DD')

This did not work.

Please suggest a solution

Thanks

Re: Display future dates in chart

Wed, 08 Jun 2016 08:31:08 GMT

Just to add to the previous post- The expression is to be added in the dimension section of a bar chart.

Re: Display future dates in chart

sunny_talwar — Wed, 08 Jun 2016 09:36:23 GMT

May be like this in your calculated dimension:

If(Dates >Today(), Dates)

Make sure to check 'Suppress When Value Is Null' on the dimension tab

Re: Display future dates in chart

sunny_talwar — Wed, 08 Jun 2016 09:38:01 GMT

Another thing to note here is that your Dates field need to be read as dual in order for this to work. Use Date#() in the script to make sure Dates are read as dual if they are not. Check the following links for more help on this topic

Get the Dates Right

Why don’t my dates work?

Re: Display future dates in chart

Digvijay_Singh — Wed, 08 Jun 2016 09:42:40 GMT

Ensure that date formats are compatible on both side of the operator.

Re: Display future dates in chart

sunny_talwar — Wed, 08 Jun 2016 09:44:24 GMT

AFAIK, If statement do not require you to have same formats. Its only an issue when using set analysis

Re: Display future dates in chart

susovan — Wed, 08 Jun 2016 09:52:15 GMT

Hi Soumya,

It might be work for your future date.

Date(Today()+1,'DD/MM/YYYY')

Re: Display future dates in chart

Digvijay_Singh — Wed, 08 Jun 2016 09:54:31 GMT

oh ok, thanks for pointing it out.

Re: Display future dates in chart

Wed, 08 Jun 2016 12:29:18 GMT

Thank you for the replies.

I applied a condition as (given below) on the measure and the chart now displays values only for future dates

=Sum( If ( DATE>Date(today(),'YYYY-MM-DD') , Sales))

Re: Display future dates in chart

sunny_talwar — Wed, 08 Jun 2016 12:45:44 GMT

You can replicate this using set analysis as well:

=Sum({<DATE *= {"=$(='>' & Date(Today(),'YYYY-MM-DD'))"}>} Sales)

To filter based on selection in DATE selected

=Sum({<DATE = {"=$(='>' & Date(Today(),'YYYY-MM-DD'))"}>} Sales)

To always display future dates based on selection in DATE field