Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Filter on date

Hi,

I have just created a pivot table.
Now I would like to make a choice list of the years.

I use the format for only showing the years.
But now all years are showed like 20 times, but I want every year only 1 show.
Can I use some distinct function in Qlikview?

Example:

2010

2011

2012

1 Solution

Accepted Solutions
Not applicable

Re: Filter on date

You asked to have the years only, but for presentation purpose.

For Qlikview these values are distinct dates formatted to show only the year. So they look like duplicates, but they are actually seperate values.

In General,

Listboxes will only show distinct values.

To avoid this, create a Year filed for the date you want, or you can use as an expression in the list box - Year(date)

(We create at Calender for that purpose.)

Goodluck!

3 Replies
Not applicable

Re: Filter on date

I'm not sure I understand..

Is the Date (years only) your dimension? If so, what is your expression? it depends what you want to calculate.

Not applicable

Re: Filter on date

No, year is no dimension

I just want to filter the data from the pivot table with year.

Example:

ID     Animal    Count          date

1      Cows       200        01/01/2011

2      Sheeps    100        01/01/2012

3      Horses     50          02/01/2012

Now I want to filter the orders of 2012

Now my choice list is like this

2011

2012

2012

But I want to use distinct so the list would be like this

2011

2012

Not applicable

Re: Filter on date

You asked to have the years only, but for presentation purpose.

For Qlikview these values are distinct dates formatted to show only the year. So they look like duplicates, but they are actually seperate values.

In General,

Listboxes will only show distinct values.

To avoid this, create a Year filed for the date you want, or you can use as an expression in the list box - Year(date)

(We create at Calender for that purpose.)

Goodluck!

Community Browser