topic exclude values in QlikView

exclude values

Wed, 28 Sep 2011 14:40:51 GMT

Hello,

I`ve been trying to make a table chart so show a number of transfer orders with correspondig information such as : date , article number etc.

But our ERP software makes double entries for each transfer order. I need te suppress all entries from a certain 'Transfer-from Code' which is 'IN TRANSIT'
I`ve been trying to achieve this by making an expression such as

If([Transfer-from Code]<>'IN TRANSIT',[Transfer-from Code])

But this gives wrong values

any help would be welcome

exclude values

Wed, 28 Sep 2011 15:28:35 GMT

Hi,

if u have some expression u can filter this value with set analysis:

sum({<[Transfer-from Code]-={'IN TRANSIT'}>} FIELD)

But your if seems to be correct, can you post a qvw file with a data subset?

C u,

Stefano.

exclude values

IAMDV — Wed, 28 Sep 2011 15:34:15 GMT

Stefano is right. Your IF condition seems to be right. I am assuming it is in upper case 'IN TRANSIT'.

What do you mean by wrong values? It will be easy to post the QV document.

Thanks - DV

exclude values

Thu, 29 Sep 2011 09:54:33 GMT

Thanks for all the input,

I`ve found the problem.

I used the formula as an expression.

Changed it to a calculated dimension and it gave the required results

thanks