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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jordansoares
Contributor III
Contributor III

Difficulty with Set Analysis

I'm new to qlik sense and I'm having trouble getting the result I need through Set Analysis.

I would like to count how many products are priced lower than $10. I am using the expression below but it is not working.

Count({$<price={'<10'}>}distinct(code))

the expression only returns '0'

Labels (1)
1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

Can you try it with double quotes -

Count({$<price={"<10"}>}code)

View solution in original post

5 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

have you tried Count({$<price={'<10'}>}distinct code)

jordansoares
Contributor III
Contributor III
Author

already! Nothing changed

neelamsaroha157
Specialist II
Specialist II

Can you try it with double quotes -

Count({$<price={"<10"}>}code)

lironbaram
Partner - Master III
Partner - Master III

hi 

does price field and code fields are in the same table 

 

jordansoares
Contributor III
Contributor III
Author

it works double quotation marks. thank you