eliminating - values from the front or through script

[qlikviewwizard]

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.

[#2]

How do you have your data model?

Can you post sample application.

[#3]

Hi,

Try where clause :

where not isnull(primary Key);

Hope this will help you.

[MayilVahanan]

Hi

In that, JOB is dimension or expression. Suppose if its a expression, please use in Dimension.

[qlikviewwizard]

kSindhuKannan‌

Please find the attachment. Thank you.

[qlikviewwizard]

Hi MayilVahanan

Job is a Dimension. Thank you.

[settu_periasamy · Accepted solution]

Hi,

Can you check this attachment? still if you get the null values, let us know your QV version.

[qlikviewwizard]

My QV version is this.

[qlikviewwizard]

Hi settu_periasamy

But for me it is not working.

[qlikviewwizard]

=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.