Discussion board where members can get started with QlikView.
I am having a date field named 'CalenderDate' which is in 'DD/MM/YYYY HH:MMSS' format. I Want to only show 'HH' part of it in list box. The data is similar to below
so there are multiple records for one date each having different time stamp.
To show only 'HH' part in list box, I am using formula as =Date(CalenderDate, 'HH); it is returning HH part, but it is duplicating.
As you can see there are two records having time stamp 10:15 and 10:16; so it is showing 10 two times in list box.
I want to display it only once. Does anyone knows how to achive this?
Thanks in advance.
Just use the expression date(floor(num(Date)),'HH') as Hour1.
I think it will sort your problem and will give distinct record in base of hours.
It is showing duplicates because it still sees a distinct serial number, just in a different format. If you click one of the 10's, you will notice that it likely returns only that individual record. To get around this, I recommend using a Master Calendar. You can add an Hour field in the script.
I came across same issue and i know it is too late but i tried below expression in the script and got the result
Hope this works for you too