Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ColtE8
Contributor III
Contributor III

Graph dealing with dates

Hello!

I have a graph that shows datapoints happening within a specific year. The data input from excel is in a date format mm/dd/yyyy. There are no "open" points in previous years (2020,2021,2022) and we want to remove those from the graph but we can't get the formula to work.

Right now we have:

=Right([Completion Date],4)

I told it to eliminate null values but can't figure out how to write the formula to identify null values.

Thanks,

Colton Esman
https://www.linkedin.com/in/colton-esman/
Labels (6)
1 Solution

Accepted Solutions
ColtE8
Contributor III
Contributor III
Author

I actually got this. I simply pulled in only open points, was just overthinking it.

Answer was: =if([Data_Open]>0,(Right([Completion Date],4)))

Thanks,

Colton Esman
https://www.linkedin.com/in/colton-esman/

View solution in original post

1 Reply
ColtE8
Contributor III
Contributor III
Author

I actually got this. I simply pulled in only open points, was just overthinking it.

Answer was: =if([Data_Open]>0,(Right([Completion Date],4)))

Thanks,

Colton Esman
https://www.linkedin.com/in/colton-esman/