Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

I want to put a background and numbers

I want to put the background and digits of the maximum up to the value 10.01.

 

Paknanarn23_1-1663728547563.png

 

Labels (2)
2 Solutions

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

By using Visual Cues as below

O/P

BrunPierre_0-1663746587325.png

Settings

BrunPierre_1-1663746659852.png

View solution in original post

Paknanarn23
Creator II
Creator II
Author

thank you very much

View solution in original post

4 Replies
sidhiq91
Specialist II
Specialist II

@Paknanarn23  You can write something like below in your expression.

if(Sum(LineSalesAmount)/Sum(Total LineSalesAmount)<0.1,Sum(LineSalesAmount)/Sum(Total LineSalesAmount))

This is to basically to restrict the values less than 10%

Paknanarn23
Creator II
Creator II
Author

I want to put color in the number field as shown in the picture.

Paknanarn23_0-1663740148620.png

 

BrunPierre
Partner - Master II
Partner - Master II

By using Visual Cues as below

O/P

BrunPierre_0-1663746587325.png

Settings

BrunPierre_1-1663746659852.png

Paknanarn23
Creator II
Creator II
Author

thank you very much