topic Re: 2 calculated columns in pivot at defined position. in App Development

2 calculated columns in pivot at defined position.

meenakshi_m — Mon, 01 Mar 2021 11:58:41 GMT

hello everyone.

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

Re: 2 calculated columns in pivot at defined position.

rbartley — Mon, 01 Mar 2021 12:17:42 GMT

Hi,

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

Re: 2 calculated columns in pivot at defined position.

meenakshi_m — Mon, 01 Mar 2021 17:33:27 GMT

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.

Re: 2 calculated columns in pivot at defined position.

Saravanan_Desingh — Mon, 01 Mar 2021 18:00:10 GMT

Can u upload the Excel sheet you have showed here?

Re: 2 calculated columns in pivot at defined position.

meenakshi_m — Mon, 01 Mar 2021 18:26:30 GMT

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

Re: 2 calculated columns in pivot at defined position.

rbartley — Tue, 02 Mar 2021 09:40:04 GMT

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

Re: 2 calculated columns in pivot at defined position.

meenakshi_m — Tue, 02 Mar 2021 10:36:14 GMT

hi ,

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

Re: 2 calculated columns in pivot at defined position.

meenakshi_m — Tue, 02 Mar 2021 16:30:01 GMT

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

appreciate help

Re: 2 calculated columns in pivot at defined position.

rbartley — Wed, 03 Mar 2021 16:28:50 GMT

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.