Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
CV3318632700015920004975306720191230132509020200129C35760
CV3318632700015920004975306720191230132509120200129C35760

 

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?

Tks!

1 Reply
Highlighted
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"