topic Re: Looping through script based on a field in QlikView

Looping through script based on a field

Thu, 22 Jan 2015 08:34:51 GMT

Hi Guys

I have a table with multiple fields which i use for calculations.

For example lets say one of the fields were called Language and there were 5 different languages in the Languages field.

I need to perform different calculations for the different languages in the Language field.

My question is - Is there a way to maybe loop through the script for each language in the Lanugauge field and then store as a qvd??

If so, then i would then just call each qvd seperately and then perform the necessary calculations.

Any help would be appreciated.

Regards,

Magen

Re: Looping through script based on a field

alexandros17 — Thu, 22 Jan 2015 08:40:01 GMT

In your situation one solution can be:

AAA:

Load * resident myTable where Language = 'English';

store * from AAA into English.qvd;

Drop table AAA;

AAA:

Load * resident myTable where Language = 'French';

store * from AAA into French.qvd;

Drop table AAA;

and so on

Re: Looping through script based on a field

Thu, 22 Jan 2015 09:00:24 GMT

Hi Magen,

create a variable with a concatenated list of your possible languages and then use a for loop to cycle through each.

Set vAll_languages = 'French','English','Spanish';

For Each vlanguage in $(vAll_languages)

Table1:

Load xxxxx

From yyyy

Where Language = '$(vlanguage)'

Store Table1 Into $(vlanguage).qvd;

Drop Table1;

Next;

something along those lines, if you are doing specific code for each language though, you'd need to incorporate the adjusted code for each value in the variable.

Hope that helps

Joe

Re: Looping through script based on a field

jagan — Thu, 22 Jan 2015 09:15:31 GMT

Hi,

If you have fixed number of languages then this is the best approach

Language1:

Load * ,

SomeCalculation

resident myTable where Language = 'Language1';

store * from Language1 into Language1.qvd;

Drop table Language1;

Language2:

Load * ,

SomeCalculation

resident myTable where Language = 'Language2';

store * from Language2 into Language2.qvd;

Drop table Language2;

Or you can use If() to find the language and calculate based on the language and generate a single qvd.

Hope this helps you.

Regards,

Jagan.