Qlik Community

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
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.

page.png

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')))

View solution in original post

10 Replies
Highlighted
Contributor II
Contributor II

Re: Qlik View Expression

try use <=89

Highlighted

Re: Qlik View Expression

could you please share your qvw?

Highlighted
Partner
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
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.

page.png

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')))

View solution in original post

Highlighted
Creator
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
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
Creator

Re: Qlik View Expression

how to count no of silver ,gold & Diamond.