get result by count qliksense

[UserID2626]

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

[sunny_talwar · Accepted solution]

Try this expression for your chart on 2nd sheet

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

[nishanthi_8]

You can try this expression too.....

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

[nsetty]

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?