Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
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"