Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Could somebody let me know what is wrong in this expression, I receive always NULL.
Thanks
Hello Joaquin,
Based on your current data model and chart configuration, it seems that if the above condition is true, then the response would be 1, otherwise, you would get a 0.
Would it be satisfactory for you to simplify your expression to:
If(Sum ({<FISCALCY={"$(=max( FISCALCY))"} >} REGSLSRTL) <>0, 0, 1)
Regards,
Philippe
Hello Joaquin
I believe the double quote characters are missing:
Count(if (Sum ({<FISCALCY={"$(=max( FISCALCY))"} >} REGSLSRTL) <>0 ,'', CURSKN))
Regards,
Philippe
I have the same results. NULL.
Try Count(if (Sum ({<FISCALCY={'$(=max( FISCALCY))'} >} REGSLSRTL) <>0 ,'', CURSKN))
Attached is the QVW
I have the same result NULL
De: Martin Mahler
Enviado el: lunes, 21 de abril de 2014 17:37
Para: Salmerón, Joaquín
Asunto: Re: - Expression
Qlik Community<http://community.qlik.com/>
Expression
reply from Martin Mahler<http://community.qlik.com/people/mahlerma?et=watches.email.thread> in App Development - View the full discussion<http://community.qlik.com/message/512617?et=watches.email.thread#512617>
Couple of issues:
Sorry, My dimension is also CURSKN and I want to count CURSKN when SUM expression is not zero
De: tresesco
Enviado el: lunes, 21 de abril de 2014 17:58
Para: Salmerón, Joaquín
Asunto: Re: - Expression
Qlik Community<http://community.qlik.com/>
Expression
reply from tresesco<http://community.qlik.com/people/tresesco?et=watches.email.thread> in App Development - View the full discussion<http://community.qlik.com/message/512644?et=watches.email.thread#512644>
Hello Joaquin,
Based on your current data model and chart configuration, it seems that if the above condition is true, then the response would be 1, otherwise, you would get a 0.
Would it be satisfactory for you to simplify your expression to:
If(Sum ({<FISCALCY={"$(=max( FISCALCY))"} >} REGSLSRTL) <>0, 0, 1)
Regards,
Philippe
Joaquin,
Using your chart in the supplied QVW, I created the following expression that I named REGSLSRTL_Sum
Sum ({<FISCALCY={"$(=max( FISCALCY))"} >} REGSLSRTL)
Then I created this new expression:
If(REGSLSRTL_Sum<>0, Count(CURSKN))
This expression displays either 1 or Null based on whether the retail sales for the current fiscal year are different than 0 or not. If you wish, you map opt to hide the column using the "Hide Column" option under the Presentation tab.
Regards,
Philippe