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
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>
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>
Hello Joaquin,
You do not get the following result?
Yes, but when you count the CURSKN in each category doesn't work
I think I understand. Please add the DISTINCT term in the Count() expression as such:
If(REGSLSRTL_Sum<>0, Count(DISTINCT CURSKN))
Regards,
Philippe
Is not working the correct number is 8.385 (CURSKN))
Hmm... Are you sure you are expecting a count?
Usually, counting elements shall not return fractional numbers
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>