topic How to compare date in QlikView

How to compare date

Fri, 14 Jan 2011 09:07:04 GMT

Hi,

How to use Analysis set to compare date:

I have two datetime parameters: Entered datetime and Completion Datetime. I want to get the Amount aggregation based on the datetime between Entered and Entered +7, I use this one, but it doe not work.

Sum({$<CompletionDate={$(<=DateEntered+7)}>}Amount)

Could you help me out? Thanks.

How to compare date

sparur — Fri, 14 Jan 2011 10:03:27 GMT

Hello, Isaac

try this:

Sum({$<CompletionDate={">=$(vDateEntered)<=$(=$(vDateEntered)+7)"}>}Amount)

where vDateEntered - variable with you value.

How to compare date

Fri, 14 Jan 2011 10:10:32 GMT

Hi,

I need to use DateEntered as a field not Variable. Because I will put a dimension into chart.

And I have tested, this works:

sum({$<CompletionDate={"<=$(=(DateEntered))"}>}amount) ,

But how can I add 7 days into it.

How to compare date

Fri, 14 Jan 2011 10:24:49 GMT

Hi Isaac,

please check the format of your fields "CompletionDate" and "DateEntered+7".

Maybe you are comparing a string with a number.

Are you able to upload a short example of your data (*.qvw hopefully)?

Rainer

How to compare date

sparur — Fri, 14 Jan 2011 10:25:05 GMT

Can you post a small qvw example?

How to compare date

Fri, 14 Jan 2011 10:28:15 GMT

Hi,

My Datetime format is '2010/01/01 00:00:00'