comparing the values

[Anonymous]

Hi,

I am attaching the application where I need to compare the existing column to the previous column and the resulted value in another column.

[JonnyPoole]

Like this ?

[Anonymous]

Jonathan Poole is right - use the expression he suggests.

[Anonymous]

Yes Jonathan

The sales of 2000Q1 in column QuarDIff should be zero and the rest of the values should be compared with the salesYear values and the difference should be placed in the  QuarDiff

Can you share the sample app

[JonnyPoole · Accepted solution]

Here is the attachment

[Anonymous]

Hi Jonathan ,

http://community.qlik.com/message/627479#627479

I need all the data to be shown and  I am seeking your suggestions on the above post regarding the sub-field issue.

Hope you would resolve my issue