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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.