Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fatihsahin
Partner
Partner

Same value twice in the listbox

Hi,

I am experiencing a strange error right now:

In a listbox it is showing the same value twice:

Any Explanation?

Kind regards

5 Replies
raghvendrasingh
Creator II
Creator II

Hi,

Could you please attach QVW.

So that we can help better.

Regards,

Raghvendra

jonasheisterkam
Partner
Partner

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

robert_mika
Master III
Master III

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
MVP
MVP

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
MVP
MVP

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)

1.png