Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
giomedeiros
Contributor II
Contributor II
‎2020-05-08 07:05 PM

Set Analysis

Gostaria de traduzir esta expressão para set Analysis, mas não estou conseguindo o mesmo resultado.

 

sum( Aggr(Rangesum (Above (count(distinct if([NH.AnoCriacao]=2020 and match(upper(trim([NH.NomeSituacao])),'GATE X'),[ID PossibilidadeNN])),0,RowNo())),nn.NomeEmpregado,[NH.Trimestre])).

 

Trata-se de uma soma acumulada, agrupada por empregado e trimestre.

Alguma sugestão ?

 

Obrigada,

Labels (1)
Labels
325 Views
0 Likes
0 Replies