Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pegar a Primeira Linha do grafico

Bom Dia Pessoal,

Tenho um uma informação de saldo que funciona assim

1  Linha   campo saldo 82, qtd retirada 10
2 linha   campo saldo  71 , qtd entrada 5

eu preciso pegar o 82 somente e chamar ele de saldo inicial, se fosse via script usaria o Peek, ja tentei com first e above nao funcionou alguem tem alguma outra ideia?

tentei:

First(Saldo)

First(min(saldo))

First(sum(saldo))

above(sum(saldo))

1 Solution

Accepted Solutions
Not applicable
Author

Well I think this work

Only(if(Aggr(Rank(sum([QtdSaldo])),Documento)=1,[QtdSaldo]))

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Try the function TOP()

Not applicable
Author

Could you give a example please?

i try :

top(Saldo)

top(sum(saldo))

but not work

Not applicable
Author

Well I think this work

Only(if(Aggr(Rank(sum([QtdSaldo])),Documento)=1,[QtdSaldo]))