- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
eliminating - values from the front or through script
Hi All,
I am getting '--' values in expression values.
I want to eliminate these values. How to do that.
I tried the presentation tab.
Presentation selection:
but still showing as below:
I want to show like below screen:
Please help me.
Thanks in advanc.
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Can you check this attachment? still if you get the null values, let us know your QV version.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How do you have your data model?
Can you post sample application.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try where clause :
where not isnull(primary Key);
Hope this will help you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
In that, JOB is dimension or expression. Suppose if its a expression, please use in Dimension.
Please close the thread by marking correct answer & give likes if you like the post.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please find the attachment. Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi MayilVahanan
Job is a Dimension. Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Can you check this attachment? still if you get the null values, let us know your QV version.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My QV version is this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But for me it is not working.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
=RangeSum(Before(Sum({<Year=, Quarter=, Month=,Date={'>=$(=vStartDate)<=$(=vMaxDate)'}>} SAL), 0, 4))
This expression is giving zero values but not eliminating when I select suppress zero ,suppress missing values.
Please help.
- « Previous Replies
-
- 1
- 2
- Next Replies »