topic Re: Same value twice in the listbox in QlikView

Same value twice in the listbox

fatihsahin — Sun, 04 Oct 2015 06:26:58 GMT

Hi,

I am experiencing a strange error right now:

In a listbox it is showing the same value twice:

Any Explanation?

Kind regards

raghvendrasingh — Sun, 04 Oct 2015 06:32:21 GMT

Hi,

Could you please attach QVW.

So that we can help better.

Regards,

Raghvendra

jonasheisterkam — Sun, 04 Oct 2015 06:40:11 GMT

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

robert_mika — Sun, 04 Oct 2015 06:50:46 GMT

Do you have Dates converted to Month/Year format?

That will end up with double values as well.

Feeling Qlikngry?

jagan — Sun, 04 Oct 2015 07:04:59 GMT

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 — Sun, 04 Oct 2015 07:32:17 GMT

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)