topic Re: Script in QlikView

Script

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

I have to achieve a condition in the edit script ..which is like below

if year is less than Today then it has to executive a table

Load

Year

Mnth

office

Dept,

.from /..........qvd

else

the other table has to be executed

year

Dept

Sect

. from /....qvd

can someone help me in writing this in the edit script

Thanks in Advance

Re: Script

micheledenardi — Mon, 05 Jun 2017 06:17:20 GMT

Hi John,

The first table have only one row ?

Have we to check the first/last row of the first table to check the condition ?

Re: Script

smilingjohn — Mon, 05 Jun 2017 06:33:56 GMT

Hi Michele De Nardi

The requirement is like

If the Year is < than today then it has to executive the table called " Income Tax" else it has to Executive the the table

"Funds" i only tried to show u the sample example by taking fields

What iam trying to do is like this

IF year<= Today

Load

Year

Month

Incometax

travel

FROM

Else

Load

Year

Dept

Fund

Salary

I hope you are clear now

Re: Script

Mon, 05 Jun 2017 06:39:17 GMT

first load both qvds in table A and B.

Then u can try something like this.

load *,

if( year<=year(Today()),office,dept resident A.qvd,

year,Dept,Sect resident B.qvd);

Regards

Khushboo

Re: Script

micheledenardi — Mon, 05 Jun 2017 06:39:19 GMT

Yes,

but we have to evalue the "if" statement (IncomeTax.Year < Year(today())) for each row of IncomeTax table ?

Could be something like that ?

IncomeTax:

LOAD Year,

Mnth,

office,

Dept

FROM IncomeTax.xlsx (ooxml, embedded labels, table is Sheet1);

Let vYear=peek('Year',0,'IncomeTax');

drop Table IncomeTax;

if vYear<year(today()) then

IncomeTax:

load *

FROM IncomeTax.xlsx (ooxml, embedded labels, table is Sheet1);

ELSE

Funds:

load *

FROM Funds.xlsx (ooxml, embedded labels, table is Sheet1);

end if

Re: Script

vinieme12 — Mon, 05 Jun 2017 08:30:17 GMT

Can you clarify what exactly is the YEAR? is it a field from any of the tables?

can you post some dummy data to explain what you want to achieve