topic Re: set analyse in QlikView

set analyse

Anonymous — Tue, 06 Oct 2015 06:56:15 GMT

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.

Re: set analyse

PrashantSangle — Tue, 06 Oct 2015 06:57:27 GMT

Hi,

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

Regards

Re: set analyse

sujeetsingh — Tue, 06 Oct 2015 06:58:13 GMT

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

Re: set analyse

jozisvk11 — Thu, 16 Jun 2016 09:47:41 GMT

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

Re: set analyse

PrashantSangle — Thu, 16 Jun 2016 11:46:01 GMT

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,

Re: set analyse

Anonymous — Thu, 16 Jun 2016 11:55:10 GMT

You can write like this as well?

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