topic Re: Exclude data from dimension in QlikView

Exclude data from dimension

Tue, 29 Jul 2014 15:49:43 GMT

Hi !

My question is simple, but I got stuck with it. I've got a dimension (year) on a bar chart, but there is too many informations on it.

years= 2011,2012,2013.

I want that my chart only shows me the last two years instead of all the years, without having to select them in a selection list.

how can I do it ?

Thanks in advance.

MK_QSL — Tue, 29 Jul 2014 15:51:55 GMT

Instead of year, use below expression in your list box expression

=IF(Year> Max(TOTAL Year)-2, Year)

IF(Year> Year(Today())-2, Year)

PradeepReddy — Tue, 29 Jul 2014 16:14:24 GMT

Write the calculated expression... as suggested by Manish

=IF(Year_Field>=Max(Year)-1,Year) ---Takes the 'max year' from the available data

=IF(Year_Field>=Year(today())-1,Year) -- Takes latesr 2 years data including this year

tobias_klett — Tue, 29 Jul 2014 16:19:45 GMT

put this set analysis statement in each expression:
{<Year={'>$(=(max({1}Year)-2))'}>}