topic Re: distinct value in list box in QlikView https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661914#M1062276 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i have field expdate&nbsp; and it contains all years dates.</P><P>i need show in stright table like date format (MMM-YYYY) and also i need to show only 2013 and 2014 years date like</P><P>format 'MMM-YYYY'</P></BODY></HTML> Mon, 22 Sep 2014 14:30:24 GMT 2014-09-22T14:30:24Z distinct value in list box https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661909#M1062271 <HTML><HEAD></HEAD><BODY><P><BR />Hi i have year repeating in lsit box how can i restrict distinct</P></BODY></HTML> Mon, 22 Sep 2014 13:06:04 GMT https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661909#M1062271 2014-09-22T13:06:04Z Re: distinct value in list box https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661910#M1062272 <HTML><HEAD></HEAD><BODY><P>no list box doesn't show the duplicate value actually.</P><P></P><P>May be space added into ur year, so while taking year, pls trim it</P></BODY></HTML> Mon, 22 Sep 2014 13:11:09 GMT https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661910#M1062272 2014-09-22T13:11:09Z Re: distinct value in list box https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661911#M1062273 <HTML><HEAD></HEAD><BODY><P><BR />my data is like that but i need to show distinct values</P></BODY></HTML> Mon, 22 Sep 2014 13:15:23 GMT https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661911#M1062273 2014-09-22T13:15:23Z Re: distinct value in list box https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661912#M1062274 <HTML><HEAD></HEAD><BODY><P>so u need a duplicate value in ur list box</P><P></P><P>like below</P><P></P><P>Year</P><P>2000</P><P>2000</P><P>2001</P><P>2001</P><P>2001</P><P></P><P>like this u want?</P></BODY></HTML> Mon, 22 Sep 2014 13:17:49 GMT https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661912#M1062274 2014-09-22T13:17:49Z Re: distinct value in list box https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661913#M1062275 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>What king of repetition</P><P>Date,Year, or what?</P><P></P><P>how did you calculate it?</P><P></P><P>Can you post your Script here</P><P>May be while loading use distinct keyword</P><P></P><P></P><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 22 Sep 2014 13:40:48 GMT https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661913#M1062275 ashfaq_haseeb 2014-09-22T13:40:48Z Re: distinct value in list box https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661914#M1062276 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i have field expdate&nbsp; and it contains all years dates.</P><P>i need show in stright table like date format (MMM-YYYY) and also i need to show only 2013 and 2014 years date like</P><P>format 'MMM-YYYY'</P></BODY></HTML> Mon, 22 Sep 2014 14:30:24 GMT https://community.qlik.com/t5/QlikView/distinct-value-in-list-box/m-p/661914#M1062276 2014-09-22T14:30:24Z