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

exclude values

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

3 Replies
Not applicable
Author

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.

IAMDV
Master II
Master II

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

Not applicable
Author

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