Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Qrishna
Master
Master

Help needed please

      Rating:                                   4                   3                    2                  1

Avg(Timelinessscore)                =>60%            48-59%          36-47%           <36%

i need to write an expression for a bar chart which displays only rating  

with another condition Timeliness<>0.

i have written this expression,but this seems to be worse.


= if (Timeliness<>0 ,

if(Avg(Timelinessscore)>=0.6,4,

if(Avg(Timelinessscore)>=0.48,3,

if(Avg(Timelinessscore)>=0.36,2 , 1 )))


please help me out in rewriting this expression. thanks

1 Reply
jagan
Partner - Champion III
Partner - Champion III

Hi,

Can you attach some sample file?

Regards,

Jagan.