Pls help - Find out Accounts having different Status

[#1]

Hi Team,

I know i ve to put this query to Qlikcommunity but due to the urgent need i am sending it to you.

Acc_Name	Period	Acc_Status
Account1	Mar-08	SLA
Account1	Jun-09	T&M
Account2	Mar-08	SLA
Account2	Jun-09	SLA
Account3	Mar-08	SLA
Account4	Jun-09	T&M
Account5	Mar-08	T&M
Account5	Jun-09	T&M

I have above data sample - Account wise Status over Period.

Now i have to show in qv the Accounts having different Status over Period eg. Account1 in above sample

I am using qv version 8.50.6231.5

Pls help me.

[#2]

hi arun,

can you explain me bit how you want to present the data. Bit confusing

-Raghu

[#3]

i am comparing two months data. Every account must be in same status for both months either as SLA account or T&M account.

Now i have to check if there is any mismatch.

For example, in my sample data set, Account1 is SLA account in Mar-08 but T&M in Jun-09 - This is the mismatch. I have to do it in QV.

I have tried with Peek function with Resident and Order By clause

if(Peek(accname)=accname And Peek(status)<>status,'Difference','No Difference') as Result

but it is not working. When i am putting the data in table box, Peek(accname) is giving "-" ie nothing hence i think Peek(accname) = accname is yielding false.

Dont know why it is happening.

[#4]

Hi Arum,

Check the attaced application.

- Sridhar

[#5]

Hi,

Check the latest version.

Cheers

-Sridhar

[#6]

Thanks Sridhar...