topic Re: Match check in QlikView

Match check

Wed, 25 Nov 2015 10:32:40 GMT

How do i create a dimension or expression the check another column for matching fields?

As per attachment: Create a Dimension called Unique Doc No Count that will check the 'Doc no' column. If the below field does not match the above field then mark as 1. It it matches, mark the top one a 1 and the duplicates as 0.

This is to enable to to filter for Unique Doc No.

please below attachment for further undertanding.

On Excel i would've used =IF(A2<>A1,1,0)

Regards

Charles

Re: Match check

swuehl — Wed, 25 Nov 2015 11:28:35 GMT

In you LOAD script:

LOAD

[Doc no],

If( Previous([Doc No]) = [Doc no], 0,1) as [Unique Doc No Count]

FROM YourExcel.xls;

edit:

In general, look into the inter record functions, like Previous() and Peek().

Re: Match check

marcus_sommer — Wed, 25 Nov 2015 11:29:07 GMT

Please do not double-posting: Match Cjeck

Re: Match check

buzzy996 — Wed, 25 Nov 2015 12:54:20 GMT

follow swuehl tht perfectly matches to u.

Re: Match check

Wed, 25 Nov 2015 13:02:42 GMT

Hi,

My data source is multiple tables from SQL server. Will that solution create the coloum or dimension i'm looking for?

Re: Match check

swuehl — Wed, 25 Nov 2015 14:05:06 GMT

If you concatenate all records of [Doc No] into a single table, then use above script on a table sorted by [Doc No], it should work.

Re: Match check

buzzy996 — Wed, 25 Nov 2015 14:07:54 GMT

yes,u can use the above if expression on ur sql tables in qv edit script wherever u need.

that helps to create a new dim.