Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Help with First Sorted Value + AGGR

Hi Guys,

I have this table below:

Codigo do registroIdentificacao da LojaNSU Host da transacaoData da transacaoHorario da transacaoTipo de lancamentoData de lancamentoTipo do ProdutoMeio de CapturaValor Bruto


On my field Tipo de lancamento I have 0 and 1.

I should use only the value 1 and exclude 0. 

The field Tipo de lancamento can be 0,1,2 and 3. So when I have lines with 0 and any another I need always exclude 0.

Can you guys help me to build that?


1 Reply
Contributor II
Contributor II

Hi Antonio,


Try if this works,


select the table on the right side, click on Add-ons and Unselect the "Include Zero Values"

and if you don't want to show the null values in the table which display as '-'

On the right side, select your dimension and unselect "Include Null values"