Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all! How can I show unique values in a list box? thanks a lot
List box shows only unique values only. I am not sure what exactly you are trying to achieve.
pls share ur input data and expected out put through list box,tht helps what ur expecting.
The QlikView usual behaviour is showing only distinct values inside listboxes.
Be carefull about formatting, for example, datetimes with hours and seconds formatted as pure dates can be tricky
I also think there are dual values with the same text representations but different numerical values.
e.g. if it's timestamps formatted as dates, then you could try with DayName(Timestamp) instead.
hope this helps
regards
Marco
Have happened to me, I bet is related to dates, whole date or broken down by month, day or year, if that's the case you can fix it whith the following functions in script
daystart(TimeStamp) -> use this one in case you are using the whole date in the listbox or formatting to show day only out of a date
MonthStart(TimeStamp)
YearStart(TimeStamp)