topic Re: create new record in QlikView

Create new record

Fri, 05 Jul 2013 15:06:46 GMT

Hall all,

Please take a look at the attached excel and let me know how create a new record from the same table.

I already have the "a" and "b" in my table and I want to create "a*b " .

Thanks,

IAMDV — Fri, 05 Jul 2013 15:55:53 GMT

Hi Nima,

Have you tried something like this...

temp:
LOAD customer,
sales2
FROM

(biff, embedded labels, table is [Sheet1$]);

concatenate(temp)

LOAD customer,
sales1
FROM

(biff, embedded labels, table is [Sheet1$]);

NoConcatenate(temp)

Final_Table:

LOAD *,

Sales1 + Sales2 AS TotalSales

Resident temp;

Drop Table temp;

Cheers,

Fri, 05 Jul 2013 18:00:57 GMT

Thanks for the reply,

But I just want to do the total sales for the customer a + customer b.

Any idea?

somenathroy — Sat, 06 Jul 2013 11:12:38 GMT

You may try below code snipet:

A:
LOAD *,1 as iq;
LOAD * Inline
[customer, sales
a, 100
b, 300];

Concatenate(A)
LOAD Concat(DISTINCT customer,',') as customer, sum(sales) as sales Resident A Group By iq;

DROP Field iq;

Regards,

Som