Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

5 star rating code

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?

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

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!

View solution in original post

8 Replies
Highlighted
Creator
Creator

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

Highlighted
Not applicable

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

Highlighted
Creator
Creator

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!

View solution in original post

Highlighted
Not applicable

Yes, I got this to work.

Thank you.

Highlighted
Contributor III
Contributor III

How you do that? How stars change?

Highlighted
Contributor III
Contributor III

In design? Condition! ahaha that's cool

Highlighted
Not applicable

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

Highlighted
Luminary
Luminary

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.

Rating.png