2 calculated columns in pivot at defined position.

[meenakshi_m]

hello everyone.

Attaching a screen shot with desired results .tried couple of ways but I don't get the results in required format.

[rbartley]

Hi,

Could you please post your app.  It's far easier to get help that way.

[meenakshi_m]

Hi DO not have Qlik on my laptop and cannot share from office desktop.Can you please help basically i need solution top add new columns in pivot which is difference and want to place it in 3rd column and ;last column.

[Saravanan_Desingh]

Can u upload the Excel sheet you have showed here?

[meenakshi_m]

Hi ,

have tried to do it after downloading qlik sense on the personal computer. please find the QVD file. Please guide with solution.so i would want to add 2columns one at 3rd position and other at 5th

[rbartley]

Take a look at the attached qvf file.  I  have used the Before() function to compare the value in one month with the one in the previous month

[meenakshi_m]

hi ,

This leaves an extra column with Nulls for the first column which disturbs the formatting of the table.Had tried this

[meenakshi_m]

Any other way to get this in right format. Need only 2 new columns with calculated difference.

appreciate  help

[rbartley]

Is your data static?  Why only 2 columns? What happens if there are more dates? In that case, wouldn't you want more movement columns?  When you talk about disturbing the formatting of the table, it sounds as though you have a external format that you're trying to match in the Qlik Sense app, is that right?  

The reason I am asking these questions is that they will influence how best to meet your requirement.