topic Max year is this year in QlikView

Max year is this year

Mon, 06 Jul 2015 12:34:19 GMT

In my data is information about the years 2016 and 2017.

I want make a box like this:

But now I said in my script Year is min 2012 and max 2015. But can I make a formale like this

Max year = this year, now 2015.

and 3 lower years in this case: 2012,2013,2014

Anonymous — Mon, 06 Jul 2015 12:40:36 GMT

Hi Lieko,

Though your information is not sufficient I am trying to sahre few samples

Let Max_Year=Year(Today())

Let Min_Year=2012; //Hardcoded

Ifyou have date field in your data then you can create you Min & Max year in script itself

Load Min(Year(Date_Field)) As Min_Year,

Max(Year(Date_Field)) As Max_Year

From Your_Tablename

Group by key fields;

Note:

it would be good if you share your data

alexandros17 — Mon, 06 Jul 2015 12:41:19 GMT

My example

MK_QSL — Mon, 06 Jul 2015 12:44:01 GMT

Create a List Box

Instead of Field Select Expression in Field

Use below expression

=IF(Year >= Year(Today())-3 and Year <= Year(Today()), Year)

Use Jaar as Title

Go to Presentation Tab

Untick Single Column

Tick Fixed Number of Columns as 4

now Drag the border and make single line instead of 4

ankit777 — Mon, 06 Jul 2015 12:45:53 GMT

Hi,

Are you talking about loading data for current year and last 3 years?

You can write in where condition

year<=year(today) and year >=year(today)-3

Mon, 06 Jul 2015 12:55:42 GMT

Thanks all! But special thanks for Manish Kachhia!