topic Re: Slider for Average Rating in QlikView

Slider for Average Rating

Jojo17 — Sat, 16 Nov 2024 04:52:56 GMT

There are multiple movies that has been rated between 1-5 by users in a survey. One movie can have more than one rating.

I would like to include a slider. The purpose of the slider is for user to select a range or a specific number (multi values) and to display movies with an average rating of selection.

However, the slider that I have added into my dashboard only allows selection for 1,2,3,4,5 and NOT numbers showing the average, like 3.4, 4.2 etc.

How should I configure my slider to show values that includes the average values or is there a property of the slider I should adjust?

Re: Slider for Average Rating

Anil_Babu_Samineni — Fri, 28 Dec 2018 09:08:47 GMT

May be create variable for that field. And use the same for slider using the Variable section.

Then, Min Value = Min({1} Field)

Max Value = Max({1} Field)

Static Step = 1/2/3/4/5/6 (Any one of them)

Re: Slider for Average Rating

sathishbabu_s_g — Fri, 28 Dec 2018 19:00:20 GMT

Hi Jodi,

you can have two variable such as vRatingMax and vRatingMin and they can be used on Slider with Min value of 0 and 5.

The slider will store the continuous value of min and max rating and we can use it on the calculation.