topic Re: Qlik View Expression in QlikView

Qlik View Expression

vijayit43 — Mon, 05 May 2014 19:41:54 GMT

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

Re: Qlik View Expression

mayck001 — Mon, 05 May 2014 19:50:42 GMT

try use <=89

Re: Qlik View Expression

MarcoWedel — Mon, 05 May 2014 22:08:31 GMT

could you please share your qvw?

Re: Qlik View Expression

kangaroomac — Tue, 06 May 2014 02:55:15 GMT

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.

Re: Qlik View Expression

SunilChauhan — Tue, 06 May 2014 04:05:42 GMT

use .90 as it is in %

.100

.110

inpalce of 90,100 and 110

hope this helps

Re: Qlik View Expression

Tue, 06 May 2014 04:48:25 GMT

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

Re: Qlik View Expression

ljackson — Tue, 06 May 2014 12:38:06 GMT

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

Re: Qlik View Expression

vijayit43 — Tue, 06 May 2014 13:16:41 GMT

Thanks Its Work For Me

Re: Qlik View Expression

Tue, 06 May 2014 14:36:45 GMT

Its a pleasure to help.

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

Re: Qlik View Expression

vijayit43 — Tue, 06 May 2014 17:19:43 GMT

how to count no of silver ,gold & Diamond.

Re: Qlik View Expression

Tue, 06 May 2014 17:43:54 GMT

Simply you can write the 03 if conditions in 03 expression columns and replace 'Gold', 'Silver','Diamond' with 1.

By enabling the totals you can get the count.

Eg:

Silver Count:

=if((sum(Sales)/sum(Target)*100)>=90 and (sum(Sales)/sum(Target)*100)<100,1,0)