Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

Expression and chart

Hi all,

Ihave an expression in chart below.

=count(if(MT_AVAILABILITY_ACT>0,MT_AVAILABILITY_ACT))/(count (DISTINCT ID_SEGMENT_CLASS))

I want to see rate of this expression actual value not total values I mean ratio.png

When you look at chart you see values like 40000,50000 but I want to show less than 100 percent

1 Reply
Anonymous
Not applicable

maybe u also need to count distinct MT_Available_Act?