topic Re: How to create a Table in QlikView

How to create a Table

madhubabum — Mon, 06 Jul 2015 06:53:49 GMT

Hi All

I have the following scenario,......

YearRange:

Load Max(Year) as MaxYear, Min(Year) as MinYear resident Table1;

Let vMaxYear= Peek('MaxYear',0,'YearRange');

Let vMinYear= Peek('MinYear',0,'YearRange');

Set vRangeMax=$(vMaxYear);

Set vRangeMin=$(vMinYear);

Drop Table YearRange;

Load

$(vRangeMax) as Year

Resident Table1

where Year=$(vRangeMax)-1;

Set vRangeMax= Num($(vRangeMax))-1;

LOOP while $(vRangeMax) >$(vRangeMin);

Store Table1 into 'D:\Table1.qvd';

Note : " $(vRangeMax) " is showing an error......

How we can load table...

Thanks

Madhu

Re: How to create a Table

jonathandienst — Mon, 06 Jul 2015 07:00:06 GMT

The problem is due to the $ expansion in the Set command returning a null. Although a Set command expression is not evaluated, the $ expansion happens before the Set statement. What you need to do is to defer the $ expansions. You can do this;

Let vRangeMax = '$' & '(vMaxYear)';

This prevents the $ expansion from happening in the script.

Re: How to create a Table

jonathandienst — Mon, 06 Jul 2015 07:02:31 GMT

I often do this instead:

Set vRangeMax = #(vMaxYear);

Let vRangeMax = Replace(vRangeMax, '#', '$');

This is useful for complex expressions which are awkward with the single step process - although for simple ones i would use the first suggestion.

Re: How to create a Table

madhubabum — Mon, 06 Jul 2015 07:26:31 GMT

Hi Jonathan

Thanks Your reply...

Where i want to use & Where i want to declare variables.

Thanks

Madhu

Re: How to create a Table

madhubabum — Mon, 06 Jul 2015 07:39:06 GMT

Hi Jonathan

-> Once we debug the script ...

Output :

Syntax error, missing/misplaced FROM:

Load

as Year,..........

Re: How to create a Table

jonathandienst — Mon, 06 Jul 2015 07:44:30 GMT

madhu babu wrote:

Where i want to use & Where i want to declare variables.

I don't understand the question

Re: How to create a Table

jonathandienst — Mon, 06 Jul 2015 07:44:58 GMT

madhu babu wrote:

-> Once we debug the script ...

Output :

Syntax error, missing/misplaced FROM:

Load

as Year,..........

You are probably missing a semi-colon or comma somewhere

Re: How to create a Table

madhubabum — Mon, 06 Jul 2015 07:53:29 GMT

Hi Jonathan

After Load

"$(vRangeMax)" does not recognize

Re: How to create a Table

sasiparupudi1 — Mon, 06 Jul 2015 07:57:36 GMT

change Set vRangeMax= Num($(vRangeMax))-1;

to let vRangeMax= Num($(vRangeMax))-1;

Re: How to create a Table

jonathandienst — Mon, 06 Jul 2015 08:00:37 GMT

Something is wrong with your (updated) script, but without seeing it, I cannot help you.

madhu babu wrote:

After Load

"$(vRangeMax)" does not recognize

Re: How to create a Table

sasiparupudi1 — Wed, 08 Jul 2015 07:16:43 GMT

Is your problem solved?