topic Add column to Concatenated table in QlikView

Add column to Concatenated table

Mon, 25 Jul 2011 05:47:16 GMT

Hi,

I have concatenated two tables with a flag called Model.

Model = Current Activity and ABF Activity

I have added this as a dimension to the layout, this works great.

Now what i want to do is add a column that calculates the difference between the two.

any ideas please

thanks

Kiwidave

deepakk — Mon, 25 Jul 2011 05:56:52 GMT

HI,

The easier way to do it

1) Add the first expression Model = Current Activity

2) Second Exporession will be Model = ABF Activity

3) Column(1) - Column(2).

I hope its clear.

Deepak