Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Partner - Creator III
Partner - Creator III

get result by count qliksense

i am trying to get result according to count.

Table:

name,choclate_count

aaa,5

bbb,2

ccc,1

tttt,4

ewer,23

efvcas,8

ufygh,9

gdy,24

Keeping filter pane in one sheet contains count 1 to10

if i qlik on 4 it should display name who have choclate count>4 which is in next sheet

1 Solution

Accepted Solutions
sunny_talwar

Try this expression for your chart on 2nd sheet

Sum({<name = {"=Sum(choclate_count) > If(GetSelectedCount(count) = 1, count, 0)"}>} choclate_count)

View solution in original post

4 Replies
sunny_talwar

Try this expression for your chart on 2nd sheet

Sum({<name = {"=Sum(choclate_count) > If(GetSelectedCount(count) = 1, count, 0)"}>} choclate_count)

nishanthi_8
Creator
Creator

You can try this expression too.....

=only({<choclate_count={">=$(=count)"}>}choclate_count)

nsetty
Partner - Creator II
Partner - Creator II

Is it possible not to show the rows at all? If counts are less than the selected count? (..in Qlik Sense)

sunny_talwar

Is that a question for me?