Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I’ve got them working:
= Sum({< Year = {$(=GetFieldSelections(Year)} >} Number)
=sum( {$<Year={$(=SubField(Concat(DISTINCT Year, ','), ',', 1))} >} Number)
Thanks for your reply.
firma_definitiva
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
Hi,
Your expression seem working fine. Can you upload your app/
Regards,
Sokkorn
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.
I’ve got them working:
= Sum({< Year = {$(=GetFieldSelections(Year)} >} Number)
=sum( {$<Year={$(=SubField(Concat(DISTINCT Year, ','), ',', 1))} >} Number)
Thanks for your reply.
firma_definitiva
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
I’ve got them working:
= Sum({< Year = {$(=GetFieldSelections(Year)} >} Number)
=sum( {$<Year={$(=SubField(Concat(DISTINCT Year, ','), ',', 1))} >} Number)
Thanks for your reply.
firma_definitiva
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