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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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

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.