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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
chiso_chiso
Creator
Creator

use of count, where...

Kindly assist gurus,

Attached is my sample data. I want to count totalsales where dateofsale is after 1st october, 2014. secondly, I want to count the number of names that made sales more than 5 regardless of date of sale.

Please assist.

4 Replies
chiso_chiso
Creator
Creator
Author

Attachment

mato32188
Specialist
Specialist

Hi Harrison,

see attached file, hope helps.

BR

M

ECG line chart is the most important visualization in your life.
jyothish8807
Master II
Master II

Hi Harrison,

PFA, hope it may help. I made few changes in your data. I changed the names so that I can check for the count of names who made sales more than five times.

Regards

KC

Best Regards,
KC
its_anandrjs
Champion III
Champion III

Hi,

For first query

Let Create a variable

Let vSelectDate 10/1/2014;

1. =count({< DateOfSale= { '>$(vSelectDate)'}>}totalsales)

2. Count( if(totalsales >5,Name))

    And

    By SET expression

    Count({< totalsales =  {'>5'}  >} Name)

Regards

Anand