Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
qlikviewwizard
Honored Contributor II

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:

presentation.JPG

but still showing as below:

Capture.JPG

I want to show like below screen:

Capture1.JPG

Please help me.

Thanks in advanc.

1 Solution

Accepted Solutions

Re: eliminating - values from the front or through script

Hi,

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

View solution in original post

11 Replies
Not applicable

Re: eliminating - values from the front or through script

How do you have your data model?

Can you post sample application.

Not applicable

Re: eliminating - values from the front or through script

Hi,

Try where clause :

where not isnull(primary Key);

Hope this will help you.

Re: eliminating - values from the front or through script

Hi

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

qlikviewwizard
Honored Contributor II

Re: eliminating - values from the front or through script

kSindhuKannan

Please find the attachment. Thank you.

qlikviewwizard
Honored Contributor II

Re: eliminating - values from the front or through script

Hi MayilVahanan

Job is a Dimension. Thank you.

Re: eliminating - values from the front or through script

Hi,

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

View solution in original post

Highlighted
qlikviewwizard
Honored Contributor II

Re: eliminating - values from the front or through script

My QV version is this.

Capture.JPG

qlikviewwizard
Honored Contributor II

Re: eliminating - values from the front or through script

Hi settu_periasamy

But for me it is not working.

qlikviewwizard
Honored Contributor II

Re: eliminating - values from the front or through script

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