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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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?