Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, if I wanted to count the number of entries in a speadsheet, but I only want to include the results if the count is greater than a certain number. ie. I only want to get the results back for all items that appear more than 4 times. Can anyone help me with this. Thank you very much!
have you tried something like
if(count(Names)>2, count(Names), null())
Please share a sample qwv in which you show your problem.
otherwise it would be diffcult to give precise help!
Names | |
Will | |
Will | |
Will | |
Emma | |
Emma | |
Emma | |
Charles | |
Gary | |
Phil | |
Names | Count |
Will | 3 |
Emma | 3 |
Charles | 1 |
Gary | 1 |
Phil | 1 |
Thanks for your reply. As a basic example, i have attached the above table of names. Suppose I wanted qlik sense to only show me the names that appear 3 times or more (ie. only Will and Emma), do you know a formula for achieving this? Hope this makes sense and thank you again very much for your help.
have you tried something like
if(count(Names)>2, count(Names), null())
Thats great. Thanks so much.