topic Re: Add one single column to straight table in QlikView

Add one single column to straight table

bartvanwetten — Thu, 02 Apr 2015 07:47:13 GMT

Dear all,

how can I add one single column at the end of the straight table in the attached document?

Thx for your help!

Bart

datanibbler — Thu, 02 Apr 2015 07:55:38 GMT

Hi Bart,

why, to add a column, just add a formula.

HTH

MK_QSL — Thu, 02 Apr 2015 07:59:52 GMT

Try to add one more Expression!

Colin-Albert — Thu, 02 Apr 2015 08:12:13 GMT

Add the expression or dimension you need, then you can drag the column to the required position by clicking & dragging on the column header.

Allow Drag and Drop must be enabled on the Presentation Properties of the chart. This is usually enabled by default.

pokassov — Thu, 02 Apr 2015 08:13:58 GMT

Hi all.

This question is not so simple, like looks.

Bart used horisontal straight table.

So he doesn't need 2 expression. He needs 2 dimenstions.

Bart, can you add one field in your model something like this

fieldlevel

then you have to add this field to table and hide it. Also you have to change your first dimention

dimention:

=if(fieldlevel=1,replace($(vPeriodeSelectie),'2014','2015'),'total')

bartvanwetten — Thu, 02 Apr 2015 09:18:48 GMT

Hi CepreN (sorry for the bad syntax spelling your name),

many thx for your reply, works perfect. Now I know how to manipulate straights, tailormade totals , in the future.

Kind regards,

Bart