Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

distinct value in list box


Hi i have year repeating in lsit box how can i restrict distinct

5 Replies
Not applicable
Author

no list box doesn't show the duplicate value actually.

May be space added into ur year, so while taking year, pls trim it

Not applicable
Author


my data is like that but i need to show distinct values

Not applicable
Author

so u need a duplicate value in ur list box

like below

Year

2000

2000

2001

2001

2001

like this u want?

ashfaq_haseeb

Hi,

What king of repetition

Date,Year, or what?

how did you calculate it?

Can you post your Script here

May be while loading use distinct keyword

Regards

ASHFAQ

Not applicable
Author

hi

i have field expdate  and it contains all years dates.

i need show in stright table like date format (MMM-YYYY) and also i need to show only 2013 and 2014 years date like

format 'MMM-YYYY'