Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ZoeM
Specialist
Specialist

Using Select in Field command to select non-blank values

Hello Community,

Hope you had a blessed close of year.

I have a chart which I am trying to use Set Analysis in the Select in Field action within the Text Object and I cannot seem to get it to work right.

This is my expression:

Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'},[#of Days Post VPP]=-{' '}>}Gateways) 

And truly all I need is to display everything that is not blank within the #of Days Post VPP field. I have both negative and positive values in the field and I need to capture each one and ONLY exclude blanks. 

Any help provided will be truly appreciated. 

Thanks.

 

Zoe M. 

Labels (1)
1 Solution

Accepted Solutions
ZoeM
Specialist
Specialist
Author

Thanks for the responses guys, I tried and found that the easiest way in this case was to identify the field (column) items before they come into the dashboard (using alteryx to wrangle data).

Thanks!

View solution in original post

4 Replies
Gysbert_Wassenaar

Try: Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'},[#of Days Post VPP]={"<0>0"}>}Gateways)

talk is cheap, supply exceeds demand
sivakumar1994
Contributor III
Contributor III

This expression wont work inside the select in field action. Try Select in field action seperately for fields ( [Date Type] ,Reference_Only ).

 

Regarding [#of Days Post VPP], kindly refer the below link.

 

https://community.qlik.com/t5/QlikView-Creating-Analytics/Select-Not-Null-quot-OnActivateSheet-quot-...

vishsaggi
Champion III
Champion III

May be try below:

Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'},[#of Days Post VPP]={"=Len(Trim([#of Days Post VPP]))>0"}>}Gateways)
ZoeM
Specialist
Specialist
Author

Thanks for the responses guys, I tried and found that the easiest way in this case was to identify the field (column) items before they come into the dashboard (using alteryx to wrangle data).

Thanks!