Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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
Partner - Master

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
Partner - Master

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