topic Present databox only with unique years in QlikView

Present databox only with unique years

Fri, 25 Nov 2011 09:51:14 GMT

Hello

I have a table with dates yyyy-mm-dd with more than 1000 dates between 2009 - 2011. I now what to create a databox that only shows the unique years to use as a filter.

2009

2010

2011

What I have done is to adjust the format to yyyy but all rows are shown in the box.

2009

2010

etc

Can some one please guide me to fix this.

Malte

Present databox only with unique years

Fri, 25 Nov 2011 10:02:44 GMT

Hi malte,

I think you mean a listbox when saying databox. Try to use an expression like Year(MyDate) in a listbox.

Regards,

Roland

Present databox only with unique years

Fri, 25 Nov 2011 10:12:23 GMT

Thank you for your answer.

Yes listbox is correct. Now I end up with this result?

Malte

Present databox only with unique years

Fri, 25 Nov 2011 11:19:59 GMT

Still not uniques presented.

Can someone please help me find the sollution to this?

Malte

Present databox only with unique years

Fri, 25 Nov 2011 11:41:29 GMT

Hi Malte,

Take that Year Field or Date Field and Goto Expression Tab in that Field.

if the Field is Date use the Below Expression:

if(WildMatch(Year(Date),'2009','2010','2011'),Year(Date)).

if the Field is Year then use below Expression :

if(WildMatch(YourYearFieldname,'2009','2010','2011'),YourYearFieldname)

Thanks & regards,

Santhosh Kumar G

Present databox only with unique years

Fri, 25 Nov 2011 12:23:39 GMT

Hi MAlte,

do not use expression tab of the listbox.

Please follow this exam: Create new Listbox --> General tab (= first tab) --> pull down menu "Fields" --> choose last entry (= <expression>) --> input into expression editor "Year(MyDate)".

That' it.

Roland

Present databox only with unique years

Fri, 25 Nov 2011 12:38:02 GMT

Now It works.Thank you Roland!

Have a nice weekend.