Dynamically changing count of chr(9734) .Is this possible ?

[shekhar_analyti]

Hi All ,

chr(9734) is actually star sign .

My requirement : Based on number value present in column c .. count of start in right column should change .

Ex- For Andrea in column c value is 1 , so in next column there should be a single star , which currently is .

But if c value is 2 (Barbara) ,then there should be two stars and likewise .

Note: I do not want to write multiple if for each values in column c .

Thanks & Regards

Shekar

[shekhar_analyti]

****** count of star

[Anil_Babu_Samineni]

May be this?

If(Aggr(Sum(c), Customer), Repeat(Chr(9734), Aggr(Sum(c), Customer)))

Or this

If(Sum(c), Repeat(Chr(9734), Sum(c)))

[#4]

hi,

use according to below code.

load *, pick(match(c,1,2,3,4,5,6,7,8,9,10),'*','**','***','****','*****','******','*******','********','*********','**********') as Rating,

Repeat('*',c) as rating_new Inline [

customer, c

a,1

b,2

c,3

d,4

e,5

f,6

g,7

h,8

i,9

j,10];

Output like this

Hope this help you.

Thanks.

[Siva_Sankar]

Show as much icons, object, pics as number in cell | Qlik Community

[Anil_Babu_Samineni]

This is long process, What you do if C has 1000 values. You need to do 1000 times. You can check my reply

[tresesco]

Repeat('*' , c)

Note: 'c' is assumed to be a field or column name in the chart or expression

[vinieme12 · Accepted solution]

Repeat(chr(9734),YourExpression)

You would probably want to do this on a percentage scale in your actual implementation