Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Interesting Group as Percentage

I have an interesting problem.  I would like to convert this chart's X axis into a percentage instead of the absolute number:

SyncDist.jpg

So each bar really should extend fully to 100%, and then I would just see the ratio of the sync results within each bar.  I've done this successfully before, but never when using the "class" function.

I can't post the QV file due to proprietary information contained, but here is what I have as the dimensions and expression:

Two Dimensions:

=class(aggr(UserCount,EngagementFileKey),2)

=SyncResultType

One Expression:

=Count(SyncResultType)

//I think this should be something like this, but it doesn't work since UserCount needs to be considered in the class group:

//Count(SyncResultType)/count(TOTAL <UserCount> SyncResultType)

Can anyone suggest how I can get this converted into a percentage bar?

Thanks!

0 Replies