topic Re: List Box - unique values in QlikView

List Box - unique values

clovati — Wed, 13 May 2015 16:08:35 GMT

Hi all! How can I show unique values in a list box? thanks a lot

Re: List Box - unique values

sunny_talwar — Wed, 13 May 2015 16:15:21 GMT

List box shows only unique values only. I am not sure what exactly you are trying to achieve.

Re: List Box - unique values

buzzy996 — Wed, 13 May 2015 16:19:46 GMT

pls share ur input data and expected out put through list box,tht helps what ur expecting.

Re: List Box - unique values

Clever_Anjos — Wed, 13 May 2015 17:35:41 GMT

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

Re: List Box - unique values

MarcoWedel — Wed, 13 May 2015 19:19:16 GMT

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

Re: List Box - unique values

Anonymous — Wed, 13 May 2015 19:52:11 GMT

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)