Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have year field, it has values like 2014,2015, 2016,2017, 2019,2025
But I want display 2015,2016,2017 data only.
How can I achive this dynamically....
Please help me out this issue...
Thanks
Venkey
Hi Venkey,
Use Where condition in your script.
where match(Year, 2015,2016,2017) ;
Or this
Set Var = 2015,2016,2017;
LOAD * Inline [
Year1
2014
2015
2016
2017
2019
2025] Where Match(Year1, $(Var));
Hi Try like this
Dynamically it will change.
In front end I need to display and I should have all the data for another report...
I shouldn't do filtering the data..
In table box I need to display those three years of data...
Please help me out this issue..
Thanks
Venkey
First of all, When you create table box it will consider as 3 years data
Second thing, In set analysis you need to like below
Sum({<Year = {'2015','2016','2017'}>} Sales)
Hi Venky,
There are different ways of achieving this:
1. If you are using a table box - then I suggest you create an inline table in script that has years required. Use this column as dimension.
2. In a chart, use calculated dimension if you are displaying year. Eg if(Match(Year,'2015','2016','2017'), Year) and suppress null values.
3. In a chart, in the expression use set analysis to display the years required. eg. Sum({<Year = {'2015','2016','2017'}>}Sales)
Hope this helps,
S
Hi Kumar
There's no option for a calculated dimension in a Table Box. Why don't you use
List box instead of Table box.