topic Re: Manually insert row within table in QlikView

Manually insert row within table

prma7799 — Mon, 07 Mar 2016 08:45:58 GMT

Dear All,

How to insert calculated expression as dimension.

PFA attachment for qvw file and for expected output

Thanks

Re: Manually insert row within table

tresB — Mon, 07 Mar 2016 08:53:11 GMT

Is back-end solution is an option?

Re: Manually insert row within table

tresB — Mon, 07 Mar 2016 09:24:16 GMT

If yes, check this:

Table:

Load *, RowNo() as Sort Inline

[RollNum,salary

180,300000

130,145000

120,110000

170,100000

110,50000

150,20000

140,10000

160,5000

];

Concatenate

Load

Sort+0.5 as Sort,

'Diff' as RollNum,

RangeSum(salary,-Previous(salary)) as salary

Resident Table Order by Sort Desc;

Re: Manually insert row within table

prma7799 — Mon, 07 Mar 2016 10:11:20 GMT

Hi tresesco‌,

How can we do this on front end.

Thanks

Re: Manually insert row within table

tresB — Mon, 07 Mar 2016 10:19:59 GMT

In the front-end, it would be a complex and costly procedure that would probably not be affordable in your real data. However, if you have limited number of rows in data as you have shown, a try can be given. Having said that, I strongly suggest to take this into the script as I shown above unless there is a very good reason that you can't go for script solution.