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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-12-19 10:36 AM

Percentage Woes

Hello QlikCommunity,

I'm struggling a bit with displaying my figures as a percentage, and have two questions on this. I'll try to be succinct:

1. In a "Top 5" chart, how can you compute a count as a percentage of that subset? Here's my most recent failed attempt, reading other posts.

    count(ID) / (if(aggr(rank(count(ID)),Category)<=5, count(ID)))

2. How do you see your table totals as both a count and percentage? I don't want to add a percentage expression because it is then applied to every dimension.

Labels (1)
Labels
356 Views
0 Likes
0 Replies