Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Take out common among the numbers

Hi,

Need a help. Suppose i have three numbers. From these numbers i have to find out the common number.

Example :

A, X, 10

B, X, 20

C, Y, 30


Here, 10 is common between these numbers.


How can i do it in Qlik?

Thanks in advance

11 Replies
Highlighted

It seems you are looking for GCD... see if hector‌'s approach from here work for you How to calculate the GCD(Greatest Common divisor)

Highlighted

May be like this:

ABC:

Load

    *,

    (Field3 - Previous(Field3)) as CommValue

Inline

[

Field1,Field2,Field3

A, X, 10

B, X, 20

C, Y, 30

];

noconcatenate

Temp:

Load *,

     if(CommValue = Previous(CommValue),1,0) as VariCompare

Resident ABC;

Drop table ABC;