to compare fields

[#1]

I want to display the agent field for transactions for this year and previous year.

How can I solve this?

[DavidFoster1]

That makes a bit more sense.

So your table would have the columns

CLIENT

AGENT

AGENT LAST YEAR

And the only connection in your data from CLIENT to AGENT is through transactions.

I think you are going to have to make the assumption that the AGENT field is the most common agent from transactions in the current year selected and the AGENT LAST YEAR field is the most common agent from transactions in the previous year.

something like (I have not tested these):

AGENT = firstsortedvalue(AGENT, COUNT(AGENT))

AGENT LAST YEAR = firstsortedvalue({<YEAR={"YEAR-1"}>} AGENT, COUNT(AGENT))

[mangalsk]

Hello,

PFA

Hope it works

[#4]

but te year is according to my selection so i cannot use yearnow

[mangalsk]

Hello,

try this for agent acc to year selction:

Create variable vCur=max(year1)

In list box write expression==if(year1=$(vCur),agent)

By default it will show current year agent but acc to year selection it changes

[mangalsk]

Hello,

PFA

I have updated qvw acc to your requirement.

Please check it.

[#7]

still no result as when i choose a particular agent , the agent of that year is filled but that of the previous year is left null if it is different

[mangalsk]

Hello,

You can use alternate state.

Create two alternate states in Document properties and use in list box