Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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