topic Re: Re setting LET value in QlikView

Re setting LET value

johngouws — Tue, 27 May 2014 04:51:26 GMT

Hi,

I have sets of similar data from various clients. From these I want to create initial QVD's.

I use LET to create a date variable to load the data up to.

The principle works perfectly when I connect and load from 1 data source from say tab "Client1".

However, when I try to load data from tab "Client1" and "Client2", the script fails.

When I load tab "Client2" on its own, it runs perfectly.

I have tried clearing LET with LET = before moving from Tab1 to Tab2, without success.

Any thoughts would be appreciated.

Thanks - John

Anonymous — Tue, 27 May 2014 05:08:22 GMT

Hi,

Similar data in the sense, do u have all the field names from both clients similar? try using qualify.

HTH,
Ravi N.

rwunderlich — Tue, 27 May 2014 05:11:53 GMT

Can you post your script as well as the specific error message?

-Rob

CELAMBARASAN — Tue, 27 May 2014 05:41:35 GMT

I hope somewhere you missed you out the semicolon at the end of the statement.

I guess it will be at the last statement of the Client1 tab.

To tell further you could post your script and error message.