topic Re: Concatenate Problem in QlikView

Concatenate Problem

Anonymous — Fri, 10 Jan 2014 05:25:03 GMT

I am facing a problem,

Please refer to the attached file for the script.

The issue is

The loop is working fine , but for table Open_Closed_backlog its not being concatenated,

all the variables are being assigned successfuly, the log is generated correctly without any error.

But the backlog at front end is not calculated as it should be .

Only the backlog is shown which is created for the first occurance of the loop,

all other occurance is missed.

Please help me , if I have done any mistake...

Re: Concatenate Problem

Fri, 10 Jan 2014 05:33:54 GMT

check your table structure and try to eliminate circular references if any. Can you share qvw file for further analysis.

Re: Concatenate Problem

sushil353 — Fri, 10 Jan 2014 05:39:09 GMT

Hi Nitin,

Debug your script using steps.. .

then you will be able to see how your script is working and what are the variable values at each loop...

HTH,

Sushil

Re: Concatenate Problem

rwunderlich — Fri, 10 Jan 2014 05:53:15 GMT

I'm not sure of your exact problem, but I would say that it is incorrect to have a table label following a CONCATENATE.

Concatenate(Open_Closed_backlog)

Open_Closed_backlog:

Load Month_name, ASSIGNED_GROUP,

-Rob

Re: Re: Concatenate Problem

Anonymous — Fri, 10 Jan 2014 08:06:28 GMT

PFA the qvw and qvd required for its input,

As per output, backlog should have been generated for all Assured name, while its generating for only 1

Kindly look into the issue.

Re: Concatenate Problem

rwunderlich — Fri, 10 Jan 2014 16:33:32 GMT

That's quite the complex if() statement you have to calculate the backlog field. It appears you are falling through and assigning null() at the end for those rows.

I don't see the problem right off, but I'd suggest breaking that if() down into pieces as sushil kumar suggested.

-Rob