topic Re: Date subtraction in set analysis in QlikView

Date subtraction in set analysis

inescastelhano — Thu, 25 Feb 2016 11:29:01 GMT

Hello everyone,

I have a problem in a set analysis expression: I want to know if a certain date is less than 2 days from now.

This is supposed to be the expression: [myDate]-ReloadTime()<2

This is my set analysis expression, but it does not work.

=sum({< [myDate]-Date(ReloadTime())={'<$(=2)'}>}[Count Sales])

Any help would be appreciated.

Cheers,

Ines

Clever_Anjos — Thu, 25 Feb 2016 11:30:39 GMT

=sum({< [myDate]={'<$(=Date(ReloadTime()-2))'}>}[Count Sales])

sunny_talwar — Thu, 25 Feb 2016 11:37:04 GMT

May be this:

=Sum({<myDate = {"=myDate - ReloadTime() <=2"}>}[Count Sales])

inescastelhano — Thu, 25 Feb 2016 11:41:23 GMT

Hi,

Thanks for your answer. However, it does not work, as you can see in the following print screen:

Thanks in advance.

inescastelhano — Thu, 25 Feb 2016 11:43:48 GMT

Now it works! Many thanks!