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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
joeluqlik
Contributor III
Contributor III
‎2018-01-11 08:53 PM

List box of the same field not showing the blank value while it is showing in the pivot table?

I have a field that's not showing the blank value within a list box as a choice of selection, but for the same dimension it shows the blank value among other values within a pivot table on the same sheet.  Any help on this?  Thanks!

625 Views
0 Likes
1 Solution

Accepted Solutions
joeluqlik
Contributor III
Contributor III
‎2018-01-11 09:35 PM
Author

In response to Anil_Babu_Samineni

Thanks, Anil, but I just found the solution on another link in the community by doing this to the field and it worked:

If(isnull (LetterSentDate),'NULL Value',LetterSentDate)  as [New LetterSentDate ]

View solution in original post

542 Views
2 Replies
Anil_Babu_Samineni
MVP
MVP
‎2018-01-11 09:14 PM

Can you provide sample

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
542 Views
0 Likes
joeluqlik
Contributor III
Contributor III
‎2018-01-11 09:35 PM
Author

In response to Anil_Babu_Samineni

Thanks, Anil, but I just found the solution on another link in the community by doing this to the field and it worked:

If(isnull (LetterSentDate),'NULL Value',LetterSentDate)  as [New LetterSentDate ]

543 Views