topic Re: 5 star rating code in QlikView

5 star rating code

Thu, 03 Jan 2013 17:56:17 GMT

I am trying to illustrate a rating system for my document and I need some help. The field I have [Overall Rating] contains a value 0-5. I want to be able to use those figures and display a color filled 5 star rating system.

Does anyone know how this can be accomplished?

Re: 5 star rating code

Anonymous — Thu, 03 Jan 2013 18:19:23 GMT

Do you already have images of filled and unfilled stars that you would want to use to display?

Once you have the images you can use conditional display fields on each of the five (not sure if this is the best approach performance wise but it will definitely get the job done). For example for the first filled star in the conditional show field, [Overall Rating]>=1 and for the subsequent unfilled star [Overall Rating]<1

Re: 5 star rating code

Thu, 03 Jan 2013 18:25:56 GMT

I could not figure out how to display stars in my Qlikview document, so I currently have nothing in that space.

Re: 5 star rating code

Anonymous — Thu, 03 Jan 2013 18:37:29 GMT

Try something like this. I just found some filled and unfilled star images from http://www.iconfinder.com/icondetails/49953/50/star_unfilled_icon and http://www.iconfinder.com/icondetails/14055/16/favorite_star_icon then used text objects to create the conditions. Hope this helps!

Re: 5 star rating code

Thu, 03 Jan 2013 20:03:36 GMT

Yes, I got this to work.

Thank you.

Re: 5 star rating code

farolito20 — Thu, 03 Jan 2013 22:02:23 GMT

How you do that? How stars change?

Re: 5 star rating code

farolito20 — Thu, 03 Jan 2013 22:05:54 GMT

In design? Condition! ahaha that's cool

Re: 5 star rating code

Thu, 03 Jan 2013 22:06:47 GMT

You have to create a condition under Properties --> Layout --> in the show box click conditional, then enter in your formula.

Re: 5 star rating code

barryharmsen — Thu, 03 Jan 2013 23:01:01 GMT

You could also use bundle load to include the stars in the QVW and associate them with your ranking data. This would make your expressions a lot easier. See the attached example.