Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Match Cjeck

Hi

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)

Capture.JPG

Regards

Charles

Tags (1)
1 Reply

Re: Match Cjeck

This could be done with Peek() or Previous() ? for example:

Load [Doc no], if([Doc no] <> previous([Doc no]), 1, 0) as Check Resident xyz order by [Doc no];

- Marcus