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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
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)