question on distinct in list box - Qlik Community

gerrycastellino · ‎2014-09-19

I'm creating a list box with values, based on distinct year from a ship date:

=distinct(year(ShipDate))

QV does not like this.

PrashantSangle · ‎2014-09-20

Hi,

if your shipdate in timestamp then,

Just write

Year(floor(ShipDate))

or

Year(ShipDate)

then List Box will show you only distinct value

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-09-20

you can try this

distinct(year(date(shipdate)))

Anonymous · ‎2014-09-20

Hi Gerry,

if you want to calculate year in front end not in backend then

Directly you can write in list box expression

year(date).