topic Re: Dates appear from nowhere !!! in QlikView

Dates appear from nowhere !!!

Anonymous — Fri, 03 May 2013 11:19:28 GMT

I am a newbie here, so please excuse me.

I have 2 date fields that I have created an expression that has an if statement as below

If(

[1HR Start Date]-[1HR Offer Date]

=0 ,

'0 Days',

)

However for some reason when I filter on this I get additional dates and I cannot understand why. I have exported to excel to check the formular in excel and it worksWhat am I doing wrong?

Thanks in advance

Phil

Re: Dates appear from nowhere !!!

sujeetsingh — Fri, 03 May 2013 11:26:40 GMT

Hi,

Try interval() function as

Interval(Date1-Date2,'dd')

thanks

Re: Dates appear from nowhere !!!

Anonymous — Fri, 03 May 2013 12:17:41 GMT

Both solutions are ok, but Son of Sardars works for me.

The only thing now is that I don't know how to group the days in a chart.

i.e. 0 - 7 days / 8 - 14 Days / 15 - 22 Days etc.

Any thoughts?

Thanks again

Phil

Re: Dates appear from nowhere !!!

pgrenier — Fri, 19 Jul 2013 14:08:24 GMT

Good morning Phil,

I believe the IntervalMatch() built-in function could be of some use to you for this.

Cheers,

Philippe