Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Show only Variable more than N

Hi,

I have Scatter chart and input button, where I select minimum number in each month.

I want to show tags in the chart only according to condition N_month>Input Button(Variable1).

I use an expression

count({ $< N_Month={">$(=Variable1)"}>}[FieldName])

It shows all tags.

Thanks,

1 Solution

Accepted Solutions
whiteline
Master II
Master II

2 vovan4ik:

You didn't  mention that you use alternative states.

There are two common states: default and inherited. $ - is default, while all charts if not specified use inherited state.

Remove leading $ from your set analysis expressions.

count({$< N_Month={">$(Variable1)"}>}[FieldName])

View solution in original post

14 Replies
MayilVahanan

HI

     Try like this

    

count({ $< N_Month={'>$(Variable1)'}>}[FieldName])

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
whiteline
Master II
Master II

Try without equal sign:

count({ $< N_Month={">$(Variable1)"}>} [FieldName])

To get it work N_Month and Variable1 should be numbers.

Anonymous
Not applicable
Author

My expression works, but it show all tags.

To easy understand my problem, imagine a school with classes.

I select 1 class in a list box.

My chart shows all students in this class. Then I select my minimum.

It should be show only students who has more than my Minimum.

But I see all students in the school.

MayilVahanan

HI

     Can you upload a sample file?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

updload the sample file so that we can help you with that.

whiteline
Master II
Master II

My expression works, but it show all tags.

My expression works too, and it shows only tags in a set { $< N_Month={">$(Variable1)"}>}

Anonymous
Not applicable
Author

Please see below attached file.

MayilVahanan

Hi

     Can you able to say, what your requirement..

     Its works.

     Please see the attached file.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

I select Class 1 in list box. It should be only students with capital Letters.

Chart with Variable shows all students.