Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am experiencing a strange error right now:
In a listbox it is showing the same value twice:
Any Explanation?
Kind regards
Hi,
Could you please attach QVW.
So that we can help better.
Regards,
Raghvendra
Check the number of the text, it can be different if you have dual values
Do you have Dates converted to Month/Year format?
That will end up with double values as well.
Feeling Qlikngry?
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.
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)