# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

## 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

Tags (2)
1 Solution

Accepted Solutions
MVP

## Re: get result by count qliksense

Try this expression for your chart on 2nd sheet

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

4 Replies
MVP

## Re: get result by count qliksense

Try this expression for your chart on 2nd sheet

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

Contributor

## Re: get result by count qliksense

You can try this expression too.....

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

Contributor II

## Re: get result by count qliksense

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

MVP

## Re: get result by count qliksense

Is that a question for me?