Filter values in table

[Anonymous]

Hello,

I need to show just the "VERIFY" rows.

How can I do that?

expression in status is:

if(DIF_HRS > 0.2 or DIF_HRS < -0.2,'VERIFY','OK')

I tried in limit dimension but no success.

Tks

[sunny_talwar]

Change it to this

if(DIF_HRS > 0.2 or DIF_HRS < -0.2,'VERIFY')

[Anonymous]

did it, but it keeps the "ok" rows:

[sunny_talwar]

HRS_PONSSE, HRS_CLIENTE, DIF_HRS are expressions or dimensions?

[Anonymous]

expressions:

hrs_ponsse: sum(stop_hrs)

hrs_client: sum(stop_hrs_client)

dif_hrs: hrs_ponsse - hrs_client

[sunny_talwar]

Change those also

If(Sum(stop_hrs) - Sum(stop_hrs_client), Sum(stop_hrs))

If(Sum(stop_hrs) - Sum(stop_hrs_client), Sum(stop_hrs_client))

If(Sum(stop_hrs) - Sum(stop_hrs_client), Sum(stop_hrs) - Sum(stop_hrs_client))

If(DIF_HRS > 0.2 or DIF_HRS < -0.2, 'VERIFY')

[Anonymous]

it keeps showing the "ok" rows...

[sunny_talwar]

Would you be able to share a sample qvw file?

[Anonymous]

sure. follow.

[sunny_talwar · Accepted solution]

It was my bad all the way... fixed the expressions in the attached file

If(Sum(HRS_PONSSE) - Sum(HRS_CLIENTE) > 0.2 or Sum(HRS_PONSSE) - Sum(HRS_CLIENTE) < -0.2, Sum(HRS_PONSSE))