Discussion board where members can get started with QlikView.
Need a help. Suppose i have three numbers. From these numbers i have to find out the common number.
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
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)
May be like this:
(Field3 - Previous(Field3)) as CommValue
if(CommValue = Previous(CommValue),1,0) as VariCompare
Drop table ABC;