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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis in Bar Chart

Hey Guys,

What I'm trying to do is count the number of customers that have purchases greater than 3 dates in a bar chart. The problem is when I did that I had no dimension but I want the user to be able to lasso each bar to select that group of customers.

Any other ideas on how to accomplish this one?

There are three expressions

=Count (DISTINCT {$<[Invoice Date] = {"> 39400"}>} [Customer Number])

=Count (DISTINCT {$<[Invoice Date] = {"> 39500"}>} [Customer Number])

=Count (DISTINCT {$<[Invoice Date] = {"> 39600"}>} [Customer Number])

It needs to look like this

error loading image

Labels (1)
2 Replies
disqr_rm
Partner - Specialist III
Partner - Specialist III

Hi Kristen,

See enclosed. Something quick and not-so-dirty.

Rakesh

Not applicable
Author

Hey Rakesh,

Thanks for doing that for me. Sorry I should have mentioned that the end user needs to be able to change the three dates on the fly without having to do a reload.