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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude values from a Bookmark set

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

so

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.

2 Replies
Not applicable
Author

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?

Not applicable
Author

figured it out::

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