topic Problem with date(Two Weeks) field in a group in QlikView

Problem with date(Two Weeks) field in a group

Thu, 14 Apr 2011 15:14:35 GMT

Hi All

'Two Weeks' in the group field works fine only when we don't select any dates field. But when I select any date field(Year: 2010) it is showing the repeatation of the date field.

Can some one please help me out this. It is little urgent!

Problem with date(Two Weeks) field in a group

deepakk — Thu, 14 Apr 2011 15:27:41 GMT

hi Attitude,

I am back..

use the code below

=date(trim(if(date >= '$(vMinDate)' and date < '$(vMaxDate)',date)),'dd/mm/yyyy')

Problem with date(Two Weeks) field in a group

Thu, 14 Apr 2011 17:19:24 GMT


Deepak Kurup wrote:
I am back.. 
use the code below
=date(trim(if(date >= '$(vMinDate)' and date < '$(vMaxDate)',date)),'dd/mm/yyyy')<div></div>

Looks like you are back but I am out

This solution has done the trick! Many thanks to you... I was just wondering why you were using trim? Was there was any space in the values? I thought reason may becuase we aren't passing the year field in the below condition. Got little surprised with the solution that you had given.

Please do reply on this...


 =if(date >= '$(vMinDate)' and date < '$(vMaxDate)',date)

Problem with date(Two Weeks) field in a group

deepakk — Fri, 15 Apr 2011 02:32:19 GMT

hi Attitude,

Since you are pulling data from excel there possibilities of spaces in data , and when i saw ur data for 2010 i felt the data was coming in text format and qlikview was not able to identify as date.

Hence i tried out trim then convert it into date.