topic Re: get set analysis formulas to work in QlikView

get set analysis formulas to work

Anonymous — Wed, 23 May 2012 08:36:51 GMT

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)

=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

get set analysis formulas to work

Sokkorn — Wed, 23 May 2012 08:45:30 GMT

Hi,

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

Regards,

Sokkorn

get set analysis formulas to work

masha-ecraft — Wed, 23 May 2012 08:47:52 GMT

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)

=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.

Re: get set analysis formulas to work

Anonymous — Wed, 23 May 2012 10:19:59 GMT

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

Re: get set analysis formulas to work

Anonymous — Wed, 23 May 2012 10:20:25 GMT

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