topic Re: eliminating - values from the front or through script in QlikView

eliminating - values from the front or through script

qlikviewwizard — Tue, 07 Jul 2015 07:01:07 GMT

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.

Re: eliminating - values from the front or through script

Tue, 07 Jul 2015 07:09:35 GMT

How do you have your data model?

Can you post sample application.

Re: eliminating - values from the front or through script

Tue, 07 Jul 2015 07:12:14 GMT

Hi,

Try where clause :

where not isnull(primary Key);

Hope this will help you.

Re: eliminating - values from the front or through script

MayilVahanan — Tue, 07 Jul 2015 07:14:45 GMT

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

Re: eliminating - values from the front or through script

qlikviewwizard — Tue, 07 Jul 2015 07:19:08 GMT

kSindhuKannan‌

Please find the attachment. Thank you.

Re: eliminating - values from the front or through script

qlikviewwizard — Tue, 07 Jul 2015 07:27:23 GMT

Hi MayilVahanan

Job is a Dimension. Thank you.

Re: eliminating - values from the front or through script

settu_periasamy — Tue, 07 Jul 2015 07:28:53 GMT

Hi,

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

Re: eliminating - values from the front or through script

qlikviewwizard — Tue, 07 Jul 2015 07:49:58 GMT

My QV version is this.

Re: eliminating - values from the front or through script

qlikviewwizard — Tue, 07 Jul 2015 07:53:56 GMT

Hi settu_periasamy

But for me it is not working.

Re: eliminating - values from the front or through script

qlikviewwizard — Tue, 07 Jul 2015 08:05:49 GMT

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

Re: eliminating - values from the front or through script

sasiparupudi1 — Tue, 07 Jul 2015 08:22:55 GMT

Change Job to a conditional dimension and put an if condition like if sum(sal)<>''

Re: eliminating - values from the front or through script

jagan — Tue, 07 Jul 2015 08:51:25 GMT

Hi,

When I select Supress Null and zero values it is working as expected. I am using 11.2 SR5, check whether you have any decimal values like 12.0000005 .

Regards,

Jagan.