topic Re: crosstable + calculated field in QlikView

crosstable + calculated field

pirotfab — Mon, 30 May 2016 08:10:16 GMT

Hello,

I want to creat à calculated fiels (periode) to join my calendar and ma crosstable (budget).

Periode = year*12+month

year*12 it's ok but when i add the month, it comes out an error

If someone have an idea

thanks

sunny_talwar — Mon, 30 May 2016 09:40:02 GMT

Try this may be:

BUDGET:

LOAD MOIS,

ANNEE,

COMPTE,

SECTION,

MONTANT,

ANNEE*12+Num#(MOIS) as Periode

Resident BUDGET_DATA;

pirotfab — Mon, 30 May 2016 09:42:17 GMT

Thanks Sunny

with your help,

it's Num(Num#(MOIS))

sunny_talwar — Mon, 30 May 2016 09:43:56 GMT

I don't think you need the extra Num(). Have you looked at the attachment?

pirotfab — Mon, 30 May 2016 09:48:56 GMT

ok i have not see the attachment ...

that it's ok too

thanks for all

have a good day

sunny_talwar — Mon, 30 May 2016 09:50:06 GMT

Not a problem. Have a good one.

Best,

Sunny