Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlik_
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
Wlad_Masi
Employee
Employee

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.