Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vivethakumar
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

1 Solution

Accepted Solutions

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

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)

nishanthi_8
Contributor

Re: get result by count qliksense

You can try this expression too.....

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

nsetty
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)

Re: get result by count qliksense

Is that a question for me?

Community Browser