Selecting Data of Particular Year in Table Objects in Sheets

[neerajthakur]

I would like to select data of Year 2008 only for my Table in Sheets, how can I achieve that. Please guide.

As you can see currently data of all the years are present I want to reduce them to data of only 2008.

I tried using ({$<Year={2008}>} with Measure values Promised Delivery Date and Actual Delivery Date

[sunny_talwar · Accepted solution]

Looks like they are dimensions, may be try this If(Year = 2008, [Promised Delivery Date])

[neerajthakur]

Date columns are measures, How can I ignore null values?

[sunny_talwar]

on if they are measures, try this... this should also exclude nulls for [Promised Delivery Date]

Only({<Year = {'2008'}, [Promised Delivery Date] *= {"*"}>} [Promised Delivery Date])

[neerajthakur]

I tried using it but didn't work out as expected and it shows null values too.

Then I tried creating a line chart and tried applying it there too, but didn't worked out. Dimensions aren't taking many expressions in it like measures do.

I am trying to limit the chart for 2008 [Invoice Date] Year only. and I am not able to make any selection based on date for selection  I have to click Invoice Number which is a dimension, may I know why? Please

[sunny_talwar]

Which of the two charts are you trying to do this in? Would you be able to share a sample qvf to see what you have to help you better?

[neerajthakur]

Line chart I want [Invoice Date] with month and year of  2008 only in x-axis 

Dimensions: Group - [Invoice Date], Line - [Invoice Number]

Measures - Delay in Delivery , calculated using =([Actual Delivery Date])-([Promised Delivery Date])

[sunny_talwar]

May be change your Invoice Date dimension to be a calculated one like this

If(Year([Invoice Date]) = 2008, [Invoice Date])

and then uncheck Show Null Values for this dimension