Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
xlitzdrama
Contributor II
Contributor II

Selecting Data of Particular Year in Table Objects in Sheets

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

neerajxlitz_0-1631536874056.png

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

6 Replies
sunny_talwar

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

View solution in original post

xlitzdrama
Contributor II
Contributor II
Author

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])

 

xlitzdrama
Contributor II
Contributor II
Author

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.

Capture.PNG

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?

xlitzdrama
Contributor II
Contributor II
Author

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])