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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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