topic Re: Add a new column in table in QlikView

Add a new column in table

Fri, 26 Jun 2015 15:12:52 GMT

Hello,

I have this table and i want to add a new column next 2015 with as value (SL(2015) - Sl(2014))-1.

Thks in advance

Re: Add a new column in table

Fri, 26 Jun 2015 15:31:01 GMT

I have the same probleme like here :

Variance by year on expression

Re: Add a new column in table

sunny_talwar — Fri, 26 Jun 2015 15:32:21 GMT

Do you have a sample you can attach?

Re: Add a new column in table

Gabriel — Fri, 26 Jun 2015 15:39:46 GMT

Hi,

you should do this from the script

Re: Add a new column in table

Fri, 26 Jun 2015 16:38:13 GMT

In attatch a sample

Re: Add a new column in table

sunny_talwar — Fri, 26 Jun 2015 16:49:00 GMT

Are you looking for something like this?

Re: Add a new column in table

Fri, 26 Jun 2015 17:59:28 GMT

I'm out of office but it's what i want.

I Will confirme you monday.

Thk

Re: Add a new column in table

sunny_talwar — Fri, 26 Jun 2015 18:00:29 GMT

Not a problem. Have a great weekend.

Best,

Sunny

Re: Add a new column in table

Mon, 29 Jun 2015 08:35:12 GMT

Hello,

I hope you 've had a good weekend.

It's what i want but with the replace load i lose a data in Periode dimension.

How to get around the problem ?

Re: Add a new column in table

jsingh71 — Mon, 29 Jun 2015 08:40:55 GMT

Just give a try, Remove replace Keyword and reload all the data.

Re: Add a new column in table

Mon, 29 Jun 2015 09:26:38 GMT

it doesn't work cause they don't have a same key

Re: Add a new column in table

sunny_talwar — Mon, 29 Jun 2015 10:15:48 GMT

I had to put a replace because I didn't have access to the source data file. So I added a Replace to do a partial reload. The idea is you need to concatenate another value to your Year field. So in essence a Year list box will look something like this:

Because I forcefully (using concatenation) added Diff value to the Year field.

In the attached file script, change the scrip to this:

Periode:

LOAD Year

FROM

C:\Users\babacar.sow\Desktop\Classeur1.xlsx

(ooxml, embedded labels, table is Feuil1);

Ventes:

LOAD Year,

Sales

FROM

C:\Users\babacar.sow\Desktop\Classeur1.xlsx

(ooxml, embedded labels, table is Feuil2);

Concatenate(Periode)

LOAD * Inline [

Year

Diff

];

HTH

Best,

Sunny

Re: Add a new column in table

Tue, 30 Jun 2015 13:49:37 GMT

Sorry, but it doesn't work so.

I have to find another way