topic Re: STAR ratings in QlikView

STAR ratings

Mon, 03 Mar 2014 08:52:14 GMT

I intend to use the star ratings in my dashboard where the rating from (1-5) is selected according to quantity of sales of a particular product.
Can anyone explain how will i get this functionality??
Any help will do.
Thanks in Advance

Regards,
Rohan Shetty

Re: STAR ratings

aveeeeeee7en — Mon, 03 Mar 2014 09:07:55 GMT

Use this Expression:

=if(aggr(rank(sum(sales)),product)<=5,product).

It will give you 1-5 Products means Top 5.

Change the given expression fields with your Table Fields.

Regards

Aviral Nag

Re: STAR ratings

Mon, 03 Mar 2014 09:16:10 GMT

Thanks for the reply, but what I am looking is to categorise them depending on products sold.

for Example when Total Sales=1000

*(1 star)=0-100 products sold in the selected category

**(2 Star)=100-200 products sold in the selected category

***(3 Star)=200-300 products sold in the selected category & so on.

Do you know how to implement the star ratings?(for eg:-***(3 star))

Regards,

Rohan Shetty

Re: STAR ratings

Mon, 03 Mar 2014 09:26:21 GMT

Hi Rohan,

How is your fact data?

Like quantity is a direct field or a new line for every sale?

If quantity is a direct field, it is better to handle this in script level while loading data

eg: if(quantity>0 and quantity <100, '1 star') as Rating

If latter is the case, u can derive in chart expression like

if(Count(Sold)>0 and Count(Sold<100) , '1 star')

Thanks,

Prabhu

Re: STAR ratings

Mon, 03 Mar 2014 09:33:54 GMT

Hi Rohan,

Try the class function:

Class(sum(Sales),100)

this will give you intervalls like "100< x <= 200"

You can then change the interval to suit the total sales

eg class (Sum(sales),sum(total Sales)/10)

Alternately, use the repeat(text,n) function to repeat a set of text n times

N could be a function of your total sales

=repeat('*',floor((5*sum(sales)/sum(total sales)+1)))

This will give you 1 * for 0-100, 2 ** for 101-200 sales, where the sum(total sales) = 1000

Erica

Re: STAR ratings

Mon, 03 Mar 2014 09:40:46 GMT

Thanks Prabhu for replying. I can use your formula to get the values of the products sold in the range of (1-5).But I am unable to Implement STAR Rating(for eg:-***(3 star)).How do I use the values for getting the output in star rating?

Re: STAR ratings

Mon, 03 Mar 2014 09:51:25 GMT

Can't you just hardcode the rating values? How do you want to diplay the data? Do you want *(1 star) as column name in table?

Re: STAR ratings

Mon, 03 Mar 2014 10:04:28 GMT

I can definitely hardcode it but it would be better if I could get the output similar to

Re: STAR ratings

Mon, 03 Mar 2014 10:13:49 GMT

Rohan,

Its sound a great idea can you please explain how you get star ratings in your dashboard

i mean can you share your app?

Re: STAR ratings

Mon, 03 Mar 2014 10:19:10 GMT

That is what I am trying to develop. It is possible in Microstrategy. Any Idea on how it could be done here?

Re: STAR ratings

Mon, 03 Mar 2014 10:23:21 GMT

Hi Rohan

If the text stars using repeat() are not suitable *,*** etc then there are 2 alternatives so you can use pictures:

1) Create a bar chart, with the number of sales, and overlay with an image that looks like the stars, except that the background is blank and the stars are transparent. That way the stars will "fill up" with the data from the bars, which is actually behind them. You can also do this in a table

2) Create a set of images, which look like a full star, a half star, as much detail as you want. Create a table with the product as the dimension, and 5 expressions. Check out the bundle load functionality in the script, this is how you load images. Then the expression in each one should look like:

star1:

if(sum(sales)/sum(total sales)<=0.5,'Half picture','full picture')

star2: if (sum(sales)/sum(total sales) >=1.5, 'full picture' ,

if(sum(sales) / sum(total sales) >=1,'alf picture'))

And so on

Erica

Re: STAR ratings

Mon, 03 Mar 2014 10:24:28 GMT

Rohan im asking to you.

If im at your place i will use just simple Star images and conditional hide and show.

Re: STAR ratings

Mon, 03 Mar 2014 10:32:29 GMT

The 2nd pt suggested by Erica will do!!

Prabhu

Re: Re: STAR ratings

Mon, 03 Mar 2014 11:08:40 GMT

Rohan i have got a idea please find attached file hope this will help

Re: STAR ratings

Mon, 03 Mar 2014 12:28:47 GMT

Thanks Erica And adeel

Re: STAR ratings

Anonymous — Fri, 22 Aug 2014 08:24:58 GMT

Hi,

I've defect table and want to display top 3 defect owners using expression and assign star rating to corresponding defect owners.

For Example:

Owner Name Defects Count(closed) Rating

1.Person1 25 3-star(image)

2.Person2 20 2-star(image)

3.Person3 10 1-star(image)

Note: I'm not using any aggregate functions in my queries and I want all calculations only in expression.

Thanks,

Prakash