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: 
Pujitha
Contributor II
Contributor II
‎2019-07-09 09:59 AM

Count and percentage

Hello all,

I have column called Column 1 which contains 1's,2's,3's,4's,5's repeatedly. My requirement is I need to calculate

How many are like[ Count(1's,2's,3's)/total Count (Column1)miuns(-)  Count(5's)/Total(count(Column1)] please help out how can I achieve this.

Labels (1)
Labels
409 Views
0 Likes
1 Reply
olivetwist
Creator
Creator
‎2019-07-09 01:06 PM

I think i need more info to answer this. the column is just a list of numbers from 1 to 5 repeating? you want to find how many of the values in your column match the result of your formula? or are you just looking for the result of the formula below? Sorry, its just not very clear what you are wanting the final result to be.

396 Views
0 Likes