Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
hi Attitude,
I am back..
use the code below
=date(trim(if(date >= '$(vMinDate)' and date < '$(vMaxDate)',date)),'dd/mm/yyyy')
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)
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.