Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
My example
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
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
Thanks all! But special thanks for Manish Kachhia!