topic Re: Expression in QlikView

Expression

Mon, 21 Apr 2014 14:48:36 GMT

Could somebody let me know what is wrong in this expression, I receive always NULL.

Thanks

Re: Expression

pgrenier — Mon, 21 Apr 2014 15:17:15 GMT

Hello Joaquin

I believe the double quote characters are missing:

Count(if (Sum ({<FISCALCY={"$(=max( FISCALCY))"} >} REGSLSRTL) <>0 ,'', CURSKN))

Regards,

Philippe

Re: Expression

Mon, 21 Apr 2014 15:30:34 GMT

I have the same results. NULL.

Re: Expression

simondachstr — Mon, 21 Apr 2014 15:37:05 GMT

Try Count(if (Sum ({<FISCALCY={'$(=max( FISCALCY))'} >} REGSLSRTL) <>0 ,'', CURSKN))

Re: Re: Expression

Mon, 21 Apr 2014 15:41:11 GMT

Attached is the QVW

Re: Expression

Mon, 21 Apr 2014 15:45:31 GMT

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>

Re: Expression

tresB — Mon, 21 Apr 2014 15:57:40 GMT

Couple of issues:

If we need to use one(in your case sum()) aggregation function in another(count()) one, we have to use AGGR().
It seems that you want to count CURSKN when sum()=0 against each SKN (your dimension), and SKN and CURSKN seem to be same. So you would always get 1 if the condition satisfies. Do yuo really want that?

Re: Expression

Mon, 21 Apr 2014 16:05:19 GMT

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>

Re: Expression

pgrenier — Mon, 21 Apr 2014 16:05:25 GMT

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

Re: Expression

pgrenier — Mon, 21 Apr 2014 16:20:50 GMT

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

Re: Expression

Mon, 21 Apr 2014 16:40:08 GMT

This is ok, now. Thanks a lot

De: Philippe Grenier

Enviado el: lunes, 21 de abril de 2014 18:07

Para: Salmerón, Joaquín

Asunto: Re: - Expression

Qlik Community<http://community.qlik.com/>

Expression

reply from Philippe Grenier<http://community.qlik.com/people/pgrenier?et=watches.email.thread> in App Development - View the full discussion<http://community.qlik.com/message/512648?et=watches.email.thread#512648>

Re: Expression

Mon, 21 Apr 2014 17:02:20 GMT

Philippe, your Reply is correct, but if I put in the dimension instead CURSKN, Category (that is many CURSKN in each one) doesn’t work

De: Philippe Grenier

Enviado el: lunes, 21 de abril de 2014 18:22

Para: Salmerón, Joaquín

Asunto: Re: - Expression

Qlik Community<http://community.qlik.com/>

Expression

Re: Re: Expression

pgrenier — Mon, 21 Apr 2014 17:22:24 GMT

Hello Joaquin,

You do not get the following result?

Re: Re: Expression

Mon, 21 Apr 2014 17:27:42 GMT

Yes, but when you count the CURSKN in each category doesn't work

Re: Re: Expression

pgrenier — Mon, 21 Apr 2014 17:47:36 GMT

I think I understand. Please add the DISTINCT term in the Count() expression as such:

If(REGSLSRTL_Sum<>0, Count(DISTINCT CURSKN))

Regards,

Philippe

Re: Re: Expression

Mon, 21 Apr 2014 17:57:11 GMT

Is not working the correct number is 8.385 (CURSKN))

Re: Re: Expression

pgrenier — Mon, 21 Apr 2014 18:12:22 GMT

Hmm... Are you sure you are expecting a count?

Usually, counting elements shall not return fractional numbers

Re: Expression

Mon, 21 Apr 2014 18:22:44 GMT

Yes, in the last column of the document that you show to me

De: Philippe Grenier

Enviado el: lunes, 21 de abril de 2014 20:13

Para: Salmerón, Joaquín

Asunto: Re: - Re: Expression

Qlik Community<http://community.qlik.com/>

Re: Expression