compare the current month value

[ksk278074]

Hi all ,

I having the two coloumn i.e month and POsub

if we load  two fileds in qlik it showing like below 

Now my requiremnet is comapre the jan amd feb month data 

based on the above screenshot  jan and Feb month having data like below 

jan                   feb

POMC              POMC

POMD            POMS

 based on that  jan and feb months are having same data so i need o/p as 1

and sencind row jan and feb having diffirent data so i need o/p as 0

Can you please help how to get the above data?

Thanks,

Siva

[Yoshidaqlik]

Hi,

Is it always an alphabetical order?

in line will put a valuelist

Valuelist(1,2)

in columns the months

month

in measures would be the values in the alphabetical orders

if(
  Valuelist(1,2) = 1,
  MinString(POsub),
  MaxString(POsub)
)

[ksk278074]

thanks for the reply.

here  is no alphabetical betical will come into the picture.

here want to campare the two months data  like above.

Thanks in advance