Expression

[#1]

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

Thanks

[#2]

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>

[#3]

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

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/512666?et=watches.email.thread#512666>

[pgrenier]

Hello Joaquin,

You do not get the following result?

[#5]

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

[pgrenier]

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

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

Regards,

Philippe

[#7]

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

[pgrenier]

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

Usually, counting elements shall not return fractional numbers

[#9]

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

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/512729?et=watches.email.thread#512729>