Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have FY2001,FY2002,FY2003,FY2004,FY2005 data set,
how can i get FY 2003 to FY 2004.......with the help of Where condition
Thanks
Madhu
If you want at script level
Load * From TableName Where WildMatch(Year,'*2003',*2004);
If you want at front end
Something like below
SUM({<Year = {'*2003','*2004'}>}Sales)
Hi Madhu,
You can use
Where wildmatch(Year,'FY2003','*2004');
Thanks,
Garry
Load * From ….. WHERE Match(Year, ‘2003’, ‘2004’)
Hi jsingh
Thanks to ur reply
I want to filter the data from "June-2003" to "may-2004"
Hi Madhu,
Load .... From ..... where Year>2003; this will give year from 2003 to......
what is your Date field? Is there a field is available which contains values like June-2003, July-2003 and so on?
Or share some sample data so its easy for us to give you correct solution.
Hi Madhu,
if you need to display 2003 & 2004 data at front end. Try MRKachhiaIMP
Second suggestion.It will works.
Hi,
Try this:
Load 'AllFieldsYouNeed',
Date(MonthStart('YourDateField'), 'MMM-YYYY') as [MMM-YYYY]
from TableName
where [MMM-YYYY] > Jun-2003 and [MMM-YYYY] <May-2004;