Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

aass0917
New Contributor

Please tell us about the display with limited focus

Please tell us about the display with limited focus

By finding the achievement rate with Sum ([Sales Results]) / Sum ([Target Value]),

Furthermore 100% or more, 80% to 99%, 70% or less of

It would be greatly appreciated if you could tell me how to narrow down the conditions.

 

 

3 Replies

Re: Please tell us about the display with limited focus

Do you mean this?

If(Num(Sum ([Sales Results]) / Sum ([Target Value]), '#,#0%') < 0.7, '70% or less of',

If(Num(Sum ([Sales Results]) / Sum ([Target Value]), '#,#0%') > 0.8 and Num(Sum ([Sales Results]) / Sum ([Target Value]), '#,#0%') < 0.9, '80% to 99%', '100% or more')))

Life is so rich, and we need to respect to the life !!!
OmarBenSalem
Esteemed Contributor

Re: Please tell us about the display with limited focus

but why u're formatitng it in ur condition?

there no need for that Anil

Re: Please tell us about the display with limited focus

I am thinking bit advanced, from below statement he want to use as % level

Furthermore 100% or more, 80% to 99%, 70% or less of

Sometimes, 200/100 returns 2 only but =Num(200/100, '###0%') returns 200% which is equivalent to total and create more insights. (Correct me if i am wrong)

Life is so rich, and we need to respect to the life !!!
Community Browser