Limit the results on Chart

[ivandrago]

Hi,

I have the attached Document, I only want to show data where the "New Qty" is less than the Old Qty".

So the prouctId "ABC2" should not appear? Is this possible by doing this on the chart and not through a script?

Thanks

[v_iyyappan]

Hi

Remove the New and Old Expression and add the expression like this

=If((Sum([Qty_Old]) - sum(Qty)) < 0,sum(Qty))

Regards,

[#3]

Only one thing:

If((Sum([Qty_Old]) - sum(Qty)) > 0,sum(Qty))

opposite signal!

[MayilVahanan]

Hi

PFA

[ivandrago]

Can i not have the  other expressions still showing? As I kind of need to include these to the table as well?

[ivandrago]

Can i not have the  other expressions still showing? As I kind of need to include these to the table as well?

[neetu_singh · Accepted solution]

Hi Ivan,

Please find the attached qvw. hope it will work.

Regards

Neetu Singh

[MayilVahanan]

Hi

PFA