Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Pessoal, boa tarde.
Preciso que o qlikview me traga o consolidado abaixo de R$5.000,00 de cada cliente (ID) ou seja, que cada valor de cada cliente seja somado e me traga somente os que forem abaixo de R$5.000,00. Como poderia fazer?
Hello,
where you want? in front end or in back end?
in front end, use advance set analysis
take straight table
Dimension :
1. ID
2. Cliente
Measure
=sum({<ID={"=aggr(Sum(Valor),ID)<5000"}>}Valor)
In back end
try below code
test:
Load * where Valor<5000;
LOAD Cliente,
Sum(Valor) as Valor,
ID
FROM
[C:\Users\Admin\Downloads\teste-consolidado.xlsx]
(ooxml, embedded labels, table is Planilha1)
Group By ID, Cliente
;
Regards,
Prashant Sangle
Hello,
where you want? in front end or in back end?
in front end, use advance set analysis
take straight table
Dimension :
1. ID
2. Cliente
Measure
=sum({<ID={"=aggr(Sum(Valor),ID)<5000"}>}Valor)
In back end
try below code
test:
Load * where Valor<5000;
LOAD Cliente,
Sum(Valor) as Valor,
ID
FROM
[C:\Users\Admin\Downloads\teste-consolidado.xlsx]
(ooxml, embedded labels, table is Planilha1)
Group By ID, Cliente
;
Regards,
Prashant Sangle
Olá! Muito obrigado pela ajuda, @PrashantSangle .
if it works for you then also click on like of that solution