Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Somar vendas e contar clientes com receita maior que zero

Boa tarde pessoal
 
podem me ajudar, preciso criar uma variavel onde eu possa criar uma para contar os clientes com receita maior que zero.
 
 
set vLocalMedidaQuantidadeClientesReceitaLiquida=
Count(Distinct
        {$< [%Comercial - Cenário] = {"Faturado"},
        [Comercial - Valor Total - Local] = {">0"},
        [Cliente - Código] =,
        [Cliente - Nome] = >}
        [Cliente - Código]);
CALL TratarExpansaoMacro(vLocalMedidaQuantidadeClientesReceitaLiquida);
Labels (1)
1 Reply
Highlighted
Digital Support
Digital Support

What is the result you are having?
Usually to get the calculated data of a variable you need to use =$(Variable).
What happens if you try it? What about if you use the variable value in a text & Image object?
To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.