set analyse

[Anonymous]

hi

if i write like this "avg({<psila ={'123'}>}sum_kg)

i get sum kg for feild psila=123

how do i write psila not 123 , in set analyse ?

thanks'

yarin.

[PrashantSangle]

Hi,

avg({<psila -={'123'}>}sum_kg)

Regards

[sujeetsingh]

avg({<psila -={'123'}>}sum_kg)

[jozisvk11]

Hello, I have problem with set analyse. I want to filter only values, where is the rows max. I have this, but it is not good.

Sum ({<[Rank of line] = {"$(=max([Rank of line])"} >} [Sum of income]). Thanks for helping me.

Here is my table.

ID Purchase          Row          Income  

N01                      1                  200

N02                      1                  50
N02                      2                  70

N02                      3                  60

N03                      1                  10

N03                      2                  35

N04                      1                  10

N04                      2                  40

N04                      3                  60

N04                      4                  90

N05                     1                  20

Set Analayse should choose me only this table.

ID Purchase          Row          Income  

N01                      1                  200

N02                      3                  60

N03                      2                  35

N04                      4                  90

N05                      1                  20

[PrashantSangle]

Hi,

try this in script

test:

LOAD * INLINE [

ID ,Row,Income 

N01,1,200

N02,1,50

N02,2,70

N02,3,60

N03,1,10

N03,2,35

N04,1,10

N04,2,40

N04,3,60

N04,4,90

N05,1,20

];

Final:

Load ID,max(Row) as maxRow Resident test group by ID;

Left join

Load ID, Row as maxRow,Income Resident test;

DROP Table test;

Regards,

[Anonymous]

You can write like this as well?

avg({<psila={'*'} - {'123'}>}sum_kg)