# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Search instead for
Did you mean:
Highlighted
Creator

## Qlik View Expression

My QlikView Dashboard Calculate Percentage in Expression Field When percentage >= 90 then show silver when percentage >=100 the show Gold When >=110 then show Diamond when Percentage <90 Don't show in my Qv How Is Possible ?????? Please Help...

1 Solution

Accepted Solutions
Highlighted
Not applicable

## Re: Qlik View Expression

Hi!

Hope this is what you want.

Expression of comment filed in the chart.

=if((sum(Sales)/sum(Target)*100)>=90 and (sum(Sales)/sum(Target)*100)<100,'Silver',

if((sum(Sales)/sum(Target)*100)>=100 and (sum(Sales)/sum(Target)*100)<110,'Gold',

if((sum(Sales)/sum(Target)*100)>=110,'Diamond')))

10 Replies
Highlighted
Contributor II

try use <=89

Highlighted
MVP

## Re: Qlik View Expression

could you please share your qvw?

Highlighted
Partner

## Re: Qlik View Expression

Hiya,

Not too sure if I understand your question correctly, but you should be able to get what you're looking for by either using:

• Dimension limits tab
• Show Conditional in the Expression tab
• Or if you mean literally show the colours then a guage chart should work (not sure how you'll show diamond though)

Might be best to create a simple example by using dummy data and load the qvw to better illustrate what you're after.

Highlighted
Champion

## Re: Qlik View Expression

use .90 as it is in %

.100

.110

inpalce of 90,100 and 110

hope this helps

Highlighted
Not applicable

## Re: Qlik View Expression

Hi!

Hope this is what you want.

Expression of comment filed in the chart.

=if((sum(Sales)/sum(Target)*100)>=90 and (sum(Sales)/sum(Target)*100)<100,'Silver',

if((sum(Sales)/sum(Target)*100)>=100 and (sum(Sales)/sum(Target)*100)<110,'Gold',

if((sum(Sales)/sum(Target)*100)>=110,'Diamond')))

Highlighted
Creator

## Re: Qlik View Expression

You haven't stated what you want to show if 'Silver' 'Gold' and 'Diamond' do not apply, i.e. everything below 90.

Assuming you want below 90 to show 'Bronze' change the end of your expression to this:

......110,'Diamond','Bronze')))

.

Highlighted
Creator

## Re: Qlik View Expression

Thanks Its Work For Me

Highlighted
Not applicable

## Re: Qlik View Expression

Its a pleasure to help.

Please mark it as correct answer if its work for you.

Highlighted
Creator

## Re: Qlik View Expression

how to count no of silver ,gold & Diamond.