Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filter values in table

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

1 Solution

Accepted Solutions
sunny_talwar

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))

View solution in original post

10 Replies
sunny_talwar

Change it to this

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

Anonymous
Not applicable
Author

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

sunny_talwar

HRS_PONSSE, HRS_CLIENTE, DIF_HRS are expressions or dimensions?

Anonymous
Not applicable
Author

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
Not applicable
Author

it keeps showing the "ok" rows...

sunny_talwar

Would you be able to share a sample qvw file?

Anonymous
Not applicable
Author

sure. follow.

sunny_talwar

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))