Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need expression for the following:-
1. if(season<2013) then delete all the season
2. if(season are in(9999 , 2018)) then delete
I normally use :-
MATCH(SEASON,'9999','2018')=0
If i get it straigth you want to include season over 2013 until 2018 and not equal to 9999.
If this is your case then you could add a WHERE statement in your LOAD script:
WHERE
Match(Season,'2014','2015','2016','2017')
or
WHERE
Season>2013
AND
Season<2018
Where do you want to use this expression, in a chart or script?
You want to actually delete data or hide them?
Be a little more descriptive about your problem so we can help you.
From where you want to delete it.
Can you please explain bit more.
yes, delete means I don't want to use in my calculation and if there will be some value for it then it will make it as 0.
so that it won't affect that calculation
I normally use it as 0(zero).
I want to use this expression in data load editor,
WHere I'm applying the global filter.
example :-
season: 2010,2011,2012,2013,2014
I have bar chart where dimension is "SEASON",
If i will create measure for calculating sum then it will be:
sum(Sales) which include the season from 2010 to 2014
But I want to display sales >2013.
I have a huge number of graph and tables where I'm using SEASON Value >2013 so ,everytime it's tough to apply the same filter that's why I'm applying the global filter in data load editor.
If i get it straigth you want to include season over 2013 until 2018 and not equal to 9999.
If this is your case then you could add a WHERE statement in your LOAD script:
WHERE
Match(Season,'2014','2015','2016','2017')
or
WHERE
Season>2013
AND
Season<2018