topic For Loop in QlikView

For Loop

Mon, 02 Apr 2012 12:56:12 GMT

Hi All,

I am facing one issue, my requirement is that suppose I am having onepolicy number i.e ‘1’ which contains 3 members i.e ‘222’, ‘2345’ & ‘4323’and in front of each member there is some amount. But in second case i.esuppose policy number is ‘4’ which also contains 3 members but in this caseamount is available only with one member. So I have to tag policy number 1under ‘INDIVIDUAL POLICY’ where each member is containing some amount whileother policy number i.e 4 under ‘FLOATER POLICY’ because in this case 2 membersare containing 0 amount. I am sending the sample XL for your reference. Memberremains always unique.

I have attached the Excel sheet and also achieved this.

But I need to do the same through some For Loops or While Loop, As i tried but I am not good in LOOPS..... Do any one can help me regarding this.

Let me know in case you need clarification.

For Loop

Clever_Anjos — Mon, 02 Apr 2012 13:35:54 GMT

>> Let me know in case you need clarification.
What´s your issue?

For Loop

Mon, 02 Apr 2012 17:06:52 GMT

Hi Clever,

Is there any other way to achieve this ??? through Loops or Aggr Funct or else?

For Loop

Clever_Anjos — Mon, 02 Apr 2012 19:26:07 GMT

Well, I don´t see another way, is your code working as expected?

For Loop

Tue, 03 Apr 2012 03:59:29 GMT

Yes, Its working fine .... DO you have any small app with While loop or For loop .. i have no idea how to impliment that .... I think it can be done in One to four lines of code by some loops ...

Thats what i need !!!!

For Loop

jagannalla — Tue, 03 Apr 2012 09:45:02 GMT

Hello,

I didn't workout fully.. may be it helps you to give a way

Temp:

LOAD Distinct

Amount as CAmount

FROM

Test.xlsx

(ooxml, embedded labels, table is Sheet1);

LET vCount= FieldValueCount('CAmount');

FOR i=0 to $(vCount)-1

LET vAmount = Peek('CAmount',$(i),'Temp');

IF $(vAmount)=0 then

Concatenate

LOAD *,'Floater' as Flag

FROM

Test.xlsx

(ooxml, embedded labels, table is Sheet1)

Where Amount = 0;

ELSE

Concatenate

LOAD *,'Individual' as Flag

FROM

Test.xlsx

(ooxml, embedded labels, table is Sheet1)

Where Amount <> 0;

ENDIF

Re: For Loop

Clever_Anjos — Tue, 03 Apr 2012 16:31:16 GMT

I´m sending you an app that reads all of sheets of a Excel File with a

"FOR"

(See attached file: App07 - Carga Multiplas Planilhas 2.qvw)