Exclude values from a Bookmark set

Thu, 11 Oct 2012 21:56:45 GMT

Hello,

I want to exclude values from a bookmarked set for analysis...

Here's a simple version of my bookmarked set (Set1):

-------------------------------

item CPM

tee-shirt $2.40

tee-shirt $2.45

pencil $0.30

umbrella $10.30

-------------------------------

I have an input box that will allow a user to enter a minimum value for analysys. I've assigned the variable "Set1_MinCPM" to that user entered value.

---------------------------------------------------------------------------------

Let's say for this example that user entered value is: $2.40

Set1_MinCPM = $2.40

---------------------------------------------------------------------------------

Now I want to count the number of instances where the cost is >= to $2.40... I'm having problems figuring it out.

This is what I've struggled through so far:

=Count({Set1<CPM={Set1_MinCPM>}CPM)

(count the number of times that the CPM = $2.40) This gives me 0, but it should give me 1

=Count({Set1<CPM={>Set1_MinCPM>}CPM)

(this is just an bad expression)

Any help would be appreciated.

Re: Exclude values from a Bookmark set

Fri, 12 Oct 2012 20:00:50 GMT

So this is working:

=Count({Set1<CPM-={">=3.50"}>}CPM)

but if I substitute a variable for 3.50 I it does not work.

=Count({Set1<CPM-={">=Set1_MinCPM"}>}CPM)

any advice?

Re: Exclude values from a Bookmark set

Fri, 12 Oct 2012 20:31:39 GMT

figured it out::

=Count({Set1<CPM-={"<=$(Set1_MinCPM)">}CPM)

topic Re: Exclude values from a Bookmark set in QlikView

Exclude values from a Bookmark set

Re: Exclude values from a Bookmark set

Re: Exclude values from a Bookmark set