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.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
glaubercasula
Contributor III
Contributor III

Função Day - Set Analysis

Bom dia,

Preciso dividir o faturamento em faixas de vencimento. Teoricamente faria assim:

=Sum({$< [Código]={'10','20'},Day( [Data Vencimento Fatura])={'<=10'} > } [Valor Receita Pré Pagamento])

Mas está dando erro. Qual a forma correta desse parâmetro?

Day( [Data Vencimento Fatura])={'<=10'}

1 Solution

Accepted Solutions
glaubercasula
Contributor III
Contributor III
Author

Hi,

I managed to solve as follows

=Sum({$< [Código]={'10','20'}, [Data Vencimento Fatura]={'=(Day([Data Vencimento Fatura])<=10)'} >} [Valor Receita Pré Pagamento])

Thank you for your help

View solution in original post

2 Replies
JordyWegman
Partner - Master
Partner - Master

Hi,

Please post your questions in English, this is easier to solve.

But regarding your question, try:

=Sum({$< [Código]={'10','20'},[Data Vencimento Fatura]={"<=10"} > } [Valor Receita Pré Pagamento])

You can't use a function like 'Day()' in set analysis.

Jordy

Climber 

Work smarter, not harder
glaubercasula
Contributor III
Contributor III
Author

Hi,

I managed to solve as follows

=Sum({$< [Código]={'10','20'}, [Data Vencimento Fatura]={'=(Day([Data Vencimento Fatura])<=10)'} >} [Valor Receita Pré Pagamento])

Thank you for your help