topic Re: Filter values in table in QlikView

Filter values in table

Anonymous — Fri, 04 May 2018 15:08:05 GMT

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

Re: Filter values in table

sunny_talwar — Fri, 04 May 2018 15:09:53 GMT

Change it to this

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

Re: Filter values in table

Anonymous — Fri, 04 May 2018 15:12:45 GMT

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

Re: Filter values in table

sunny_talwar — Fri, 04 May 2018 15:15:48 GMT

HRS_PONSSE, HRS_CLIENTE, DIF_HRS are expressions or dimensions?

Re: Filter values in table

Anonymous — Fri, 04 May 2018 15:18:44 GMT

expressions:

hrs_ponsse: sum(stop_hrs)

hrs_client: sum(stop_hrs_client)

dif_hrs: hrs_ponsse - hrs_client

Re: Filter values in table

sunny_talwar — Fri, 04 May 2018 15:20:58 GMT

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

Re: Filter values in table

Anonymous — Fri, 04 May 2018 16:21:53 GMT

it keeps showing the "ok" rows...

Re: Filter values in table

sunny_talwar — Fri, 04 May 2018 16:26:39 GMT

Would you be able to share a sample qvw file?

Re: Filter values in table

Anonymous — Fri, 04 May 2018 16:36:42 GMT

sure. follow.

Re: Filter values in table

sunny_talwar — Fri, 04 May 2018 16:39:44 GMT

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

Re: Filter values in table

Anonymous — Fri, 04 May 2018 16:46:45 GMT

gr8 friend.I was starting thinking about this.

this is the solution.

Thank you so much

when is possible, could you look at this issue please?

previous value with condition

Appreciate your attention!!!