topic Re: Script in QlikView

Script

Wed, 09 Oct 2013 06:42:18 GMT

Hi everyone,

i need to get the count of two columns from same table and put it into separate table.

For this i have to write a script so please help me on this.

Thanks in advance

Regards,

Sudha Banakar

Re: Script

MayilVahanan — Wed, 09 Oct 2013 06:47:55 GMT

Try like this

MainTable:

Load ProductID, Category, Product From tablename;

Table1:

Load ProductID, Count(Product) As ProductCount Resident MainTable Group by ProductID;

Table2:

Load ProductID, Count(Category) As CategoryCount Resident MainTable Group by ProductID;

Edit:

Forget to give group by

Re: Script

sujeetsingh — Wed, 09 Oct 2013 07:00:16 GMT

Hi,

If it is to be added to another table then go for join or concat

Else just you want to get it in another table with same data then the one provided by Mayil is best

Re: Script

Wed, 09 Oct 2013 07:00:49 GMT

Hello Sudha,

You can try below, But you should have a Key field to join these counts to rest of the data model and for that you would need to use the Group By Clause.

Maintable:

LOAD * INLINE [

ProductID, Category, IsTraded, IsShipped

123, Iphone, 0, 0

124, samsung, 1, 1

125, Iphone, 1, 0

126, Iphone, 1, 1

127, Iphone, 1, 1

];

CountTable:

LOAD

sum(IsTraded) as TotalTraded,

sum(IsShipped) as TotalShipped

Resident Maintable;

Thanks,

ASINGH