topic Match Expression> remove everything not matching in QlikView

Match Expression> remove everything not matching

Fri, 12 Mar 2010 18:46:44 GMT

I would like to display all the fields equal to or that match 'Y' for the projected_order field. Currently I can only identify those matching fields and can not figure out how not to display them in my chart. For example those values whose projected_order = 'N' or null for example I would like them not to display in the chart.

This should be fairly easy but I am missing something. I would like it to function in the same way QV does natively when you select 'Y' for this field.

Currently I am using an expression in a chart.


=match(projected_order, 'Y' )

Thanks for any help.

Match Expression> remove everything not matching

vgutkovsky — Fri, 12 Mar 2010 19:18:24 GMT

Jacob,

I would say either just create a calculated dimension that uses an IF statement to check whether projected_order = Y. Or use set analysis in your expression to set your project_order to Y.

Regards,

Match Expression> remove everything not matching

Fri, 12 Mar 2010 19:53:38 GMT

Vlad-

This marks all projected_orders with 1 but does not remove them. Something is wrong with the syntax. I would remove all but the ones marked with 1 to be removed from the chart.


=match(projected_order, 'N')

Thanks.

Match Expression> remove everything not matching

vgutkovsky — Fri, 12 Mar 2010 20:09:29 GMT

You're right that the syntax is incorrect. This should be your calculated dimension:

=IF(projected_order= 'Y',projected_order)

You would also need to check the "suppress when value is null" checkbox. This assumes that you have a 1-dimension, 1-expression chart. I don't know what your expression is, but you don't need to check for the value of projected_order in it. If you have a more complex chart, I would recommend using set analysis in the expression and leaving the dimension alone. For example, if your expression is a simple sum(Sales), then the expression would be:

sum({$<projected_order={Y}}Sales)

Regards,

Match Expression> remove everything not matching

Sat, 13 Mar 2010 00:23:46 GMT

If(project_order='Y',Value) use this as a caluculated dimension in your chart.This should work