Not applicable
2015-05-11
02:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to exclude null in set analysis
I have a list of account,Project id ,Amount etc.. there are few blank for Project id's ,which i want to exclude those blanks project ids in the set analysis
how to i do that ?
for example
Account | Project ID | Amount |
8150 | 100XYZ | -42459 |
8150 | -5195 |
i want to exclude -5195 value , how do i write in the set analysis ?
i tried using sum({<Project ID-={ ' '}>} Amount) but this set analysis is not working.
- Tags:
- new_to_qlikview
2,490 Views
2 Replies
2015-05-11
07:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try: {<Project ID={'*'}>} . That should filter out the nulls. If you want to filter out empty strings try {<Project ID-={''}>}
talk is cheap, supply exceeds demand
sunny_talwar
MVP
2015-05-11
08:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Somehow for me * alone did not work. I always had to use {'*?'}. If what Gysbert does not work, you can give this a try as well:
{<Project ID={'*?'}>}
HTH
Best,
Sunny
1,819 Views