topic Set Analysis in Bar Chart in QlikView

Set Analysis in Bar Chart

Wed, 06 Apr 2011 19:57:58 GMT

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

Set Analysis in Bar Chart

disqr_rm — Thu, 07 Apr 2011 00:03:18 GMT

Hi Kristen,

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

Rakesh

Set Analysis in Bar Chart

Thu, 07 Apr 2011 00:45:33 GMT

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.