Interesting Group as Percentage

Fri, 31 Jan 2014 15:49:05 GMT

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

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!

topic Interesting Group as Percentage in QlikView

Interesting Group as Percentage