topic Re: Show only Variable more than N in QlikView

Show only Variable more than N

Anonymous — Wed, 12 Sep 2012 17:06:01 GMT

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,

Re: Show only Variable more than N

MayilVahanan — Wed, 12 Sep 2012 17:08:51 GMT

Try like this

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

Hope it helps

Re: Show only Variable more than N

whiteline — Wed, 12 Sep 2012 17:11:00 GMT

Try without equal sign:

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

To get it work N_Month and Variable1 should be numbers.

Re: Show only Variable more than N

Anonymous — Wed, 12 Sep 2012 17:24:50 GMT

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.

Re: Show only Variable more than N

MayilVahanan — Wed, 12 Sep 2012 17:27:02 GMT

Can you upload a sample file?

Re: Show only Variable more than N

Anonymous — Wed, 12 Sep 2012 17:31:54 GMT

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

Re: Show only Variable more than N

whiteline — Wed, 12 Sep 2012 17:34:27 GMT

My expression works, but it show all tags.

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

Re: Show only Variable more than N

Anonymous — Wed, 12 Sep 2012 18:20:30 GMT

Please see below attached file.

Re: Show only Variable more than N

MayilVahanan — Wed, 12 Sep 2012 18:37:38 GMT

Can you able to say, what your requirement..

Its works.

Please see the attached file.

Re: Show only Variable more than N

Anonymous — Wed, 12 Sep 2012 18:42:52 GMT

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

Chart with Variable shows all students.

Re: Show only Variable more than N

Anonymous — Wed, 12 Sep 2012 18:44:05 GMT

input botton works, but I can understand how connect my botton and students

Re: Show only Variable more than N

MayilVahanan — Wed, 12 Sep 2012 18:55:28 GMT

It because, you used alternate state in multi box. So change it in default state . Then it works fine..

Re: Show only Variable more than N

Anonymous — Wed, 12 Sep 2012 18:59:44 GMT

I can't do it, because I have other charts, where I select Student and Class.

In this case I have only 1 class and 1 student in scatter charts.

Re: Show only Variable more than N

whiteline — Wed, 12 Sep 2012 19:34:42 GMT

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

Re: Show only Variable more than N

Anonymous — Wed, 12 Sep 2012 19:47:51 GMT

Yes, it was so easy.

Thank you for your help,