Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielaa
New Contributor

Set analystics

Bom dia,

eu estou criando um set analystics com duas condições porém da erro.

já mudei os () já coloquei , antes do sum nada da certo. alguém pode me ajudar?

sum((({<[Mês 1º] = {'ago'}>})sum({<[Mês 2º] = {'ago'}>}))[Valor])

att,

Daniela Lauriano.

Tags (1)
7 Replies
devarasu07
Honored Contributor II

Re: Set analystics

Hi,

can you post your question in english? attached basic set analysis document might useful for you

may be like this

Try like this,

sum({<[Mês 2º] = {'ago'},[Mês 1º] = {'ago'}>}[Valor])

vinieme12
Esteemed Contributor II

Re: Set analystics

Too many closing brackets

Sum (    

{<[Month 1] = {'ago'}>} 

     [Value] )


if you want to filter Multiple values in field then, separate by comma's

Sum (   

{<[Month 1] = {'ago','xxxx','yyy'},>}

     [Value] )

MVP
MVP

Re: Set analystics

May be this

Sum({<[Mês 1º] = {'ago'}, [Mês 2º] = {'ago'}>} [Valor])

or this

Sum({<[Mês 1º] = {'ago'}>+<[Mês 2º] = {'ago'}>} [Valor])

vinieme12
Esteemed Contributor II

Re: Set analystics

danielaa
New Contributor

Re: Set analystics

Good morning,

I try every cause, but not sucess.

att,

MVP
MVP

Re: Set analystics

Would you be able to share a sample?

agigliotti
Honored Contributor II

Re: Set analystics

what are you trying to achieve with your expression ?