Script Problem

sat_tok52 — Tue, 12 Jul 2016 16:40:28 GMT

Hi Guru's,

As per my customer requirement i have to run qvd data in UAT Server without Where condition for user testing and suppose if i moved that qvw into production server after testing completion it should run same qvd with where condition .How would i write the script.I tried like below.is It's not working ?Any help.

If vservername='UAT' then

Load

A,B

From Database

Endif

If vservername='Production' then

Load

A,B

From Database

Where Year=2015

Endif

Thanks,

Sateesh

Re: Script Problem

maxgro — Tue, 12 Jul 2016 16:47:55 GMT

Replace autogenerate with your load from db

set vservername='UAT';

If vservername='UAT' then

trace UAT;

Load

1 as A, 2 as B

AutoGenerate 100;

Endif

If vservername='Production' then

trace Production;

Load

1 as A, 2 as B

AutoGenerate 20

Where 1=1;

Endif

topic Script Problem in QlikView

Script Problem

Re: Script Problem