Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bartvanwetten
Contributor

Add one single column to straight table

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

1 Solution

Accepted Solutions
pokassov
Valued Contributor

Re: Add one single column to straight table

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

1

2

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')

5 Replies
datanibbler
Esteemed Contributor

Re: Add one single column to straight table

Hi Bart,

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

HTH

MVP
MVP

Re: Add one single column to straight table

Try to add one more Expression!

Re: Add one single column to straight table

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.

AllowDragDrop.JPG

pokassov
Valued Contributor

Re: Add one single column to straight table

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

1

2

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
Contributor

Re: Add one single column to straight table

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