Same value twice in the listbox

[fatihsahin]

Hi,

I am experiencing a strange error right now:

In a listbox it is showing the same value twice:

Any Explanation?

Kind regards

[raghvendrasingh]

Hi,

Could you please attach QVW.

So that we can help better.

Regards,

Raghvendra

[jonasheisterkam]

Check the number of the text, it can be different if you have dual values

[robert_mika]

Do you have Dates converted to Month/Year format?

That will end up with double values as well.

Feeling Qlikngry?

How To /Missing Manual(18 articles)

[jagan]

Him

If you are getting this field from a Date field then try like this

QVTableName:

LOAD

*,

Date(MonthEnd(DateFieldName), 'MM-YYYY') AS MonthName

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

[maxgro]

maybe you have a date field (left image) with many dates in one month

if you format the date in number tab (center image) you get the same number of values as your date

one solution can be to use an expression (right image) in the listbox  (=date(floor(monthstart(d)), 'MM-YYYY'))

another one could be to add a field in the script as Jahan suggested (I prefere this)