Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

get set analysis formulas to work

Hi you all,

I am trying to make this kind of formulas work, but so far without succes. I cant' get them working. Must be something wrong with the syntax but I don't know what. Please give me a push in the right direction.

=count( {$< Year={"$(Subfield(Concat (Distinct Year, ','), ',' , 1))"}>} IdNumber)

or

=sum(  {$< Year={"$(GetFieldSelections('Year'))"} Amount)

I keep getting zero as an answer while I know  I should be getting numbers far above zero. Where am I going wrong?

Thanks in advance

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I’ve got them working:

= Sum({< Year = {$(=GetFieldSelections(Year)} >} Number)

=sum( {$<Year={$(=SubField(Concat(DISTINCT Year, ','), ',', 1))} >} Number)

Thanks for your reply.

firma_definitiva

De: Sokkorn Cheav

Enviado el: miércoles, 23 de mayo de 2012 10:46

Para: Peter Blokker

Asunto: - Re: get set analysis formulas to work

<http://community.qlik.com/index.jspa> QlikCommunity

Re: get set analysis formulas to work

created by Sokkorn Cheav <http://community.qlik.com/people/sokkorn.cheav> in New to QlikView - View the full <http://community.qlik.com/message/221956#221956> discussion

View solution in original post

4 Replies
Sokkorn
Master
Master

Hi,

Your expression seem working fine. Can you upload your app/

Regards,

Sokkorn

masha-ecraft
Partner - Creator
Partner - Creator

To get a formula evaluated in the set analysis you need to put '=' sign before the formula:

=count( {$< Year={"$(=Subfield(Concat (Distinct Year, ','), ',' , 1))"}>} IdNumber)

or

=sum(  {$< Year={"$(=GetFieldSelections('Year'))"} Amount)

But as far as I can see if you just omit your set analysis you will get the same result as you are trying to apply a selection already made in a field (year) to that same field.

Anonymous
Not applicable
Author

I’ve got them working:

= Sum({< Year = {$(=GetFieldSelections(Year)} >} Number)

=sum( {$<Year={$(=SubField(Concat(DISTINCT Year, ','), ',', 1))} >} Number)

Thanks for your reply.

firma_definitiva

De: Sokkorn Cheav

Enviado el: miércoles, 23 de mayo de 2012 10:46

Para: Peter Blokker

Asunto: - Re: get set analysis formulas to work

<http://community.qlik.com/index.jspa> QlikCommunity

Re: get set analysis formulas to work

created by Sokkorn Cheav <http://community.qlik.com/people/sokkorn.cheav> in New to QlikView - View the full <http://community.qlik.com/message/221956#221956> discussion

Anonymous
Not applicable
Author

I’ve got them working:

= Sum({< Year = {$(=GetFieldSelections(Year)} >} Number)

=sum( {$<Year={$(=SubField(Concat(DISTINCT Year, ','), ',', 1))} >} Number)

Thanks for your reply.

firma_definitiva

De: Masha A

Enviado el: miércoles, 23 de mayo de 2012 10:48

Para: Peter Blokker

Asunto: - Re: get set analysis formulas to work

<http://community.qlik.com/index.jspa> QlikCommunity

Re: get set analysis formulas to work

created by Masha A <http://community.qlik.com/people/masha-ecraft> in New to QlikView - View the full <http://community.qlik.com/message/221949#221949> discussion