Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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/