topic Re: script in QlikView

script

mario-sarkis — Fri, 29 May 2015 06:50:11 GMT

please help

how can i write PeriodeDate > 'one year back' in the script ?

Re: script

Siva_Sankar — Fri, 29 May 2015 06:55:48 GMT

Load * your table where PeriodeDate = Max(Year(PeriodDate))-1;

Re: script

PrashantSangle — Fri, 29 May 2015 06:56:15 GMT

Hi,

In Script

try like

PeriodDate > Date(AddYears(PeriodDate,-1))

Note: Carefull about Date Format.

Regards

Re: script

maxgro — Fri, 29 May 2015 06:58:11 GMT

maybe this

A: // TEST DATA

load

date(makedate(2014) + floor(rand()*(365*2))) as PeriodDate

AutoGenerate 1000;

load

PeriodDate,

PeriodDate as NewPeriodDate

Resident A

where PeriodDate >= AddYears(Today(1), -1)

;

Re: script

anbu1984 — Fri, 29 May 2015 06:58:51 GMT

One year back of current year??

PeriodDate > AddYears(Today(),-1)

Re: script

nirmalraj_kj — Fri, 29 May 2015 06:58:59 GMT

Hi,

Can you try this

PeriodDate=Date(addyears(Today(),-1),'Same as PeriodDate format')

Re: script

Siva_Sankar — Fri, 29 May 2015 06:59:18 GMT

if you want only previous year data put = symbol in where, if you want data from previous year put > in where condition.

Re: script

Fri, 29 May 2015 06:59:38 GMT

Try this

PeriodeDate >Year(Now())-1

Re: script

mario-sarkis — Fri, 29 May 2015 13:21:19 GMT

hey max if the PeriodeDate it shows as number how should i write it ?

Re: script

anbu1984 — Fri, 29 May 2015 16:00:31 GMT

What is format you have in PeriodDate?

Re: script

PrashantSangle — Sat, 30 May 2015 04:16:38 GMT

Hi,

Try

PeriodDate > Num(AddYears(PeriodDate,-1))

Date(PeriodDate) > Date(AddYears(PeriodDate,-1))

Regards

Re: script

Anonymous — Sat, 30 May 2015 05:11:41 GMT

Hi,

Try this

PeriodDate > AddYears(Today(),-1)

PeriodDate = AddYears(Today(),-1)

Hope it helps!!