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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. 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

Labels (1)
1 Reply
Anonymous
Not applicable

maybe u also need to count distinct MT_Available_Act?