topic Re: Filter Single Value in QlikView

Filter Single Value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I have this situation, I've an input textfield where I can write the year and an output textfield where I wuold show a price.

Normally I could write inside the output textfield:

=sum({<year = {$(vYearIn)}>}value)

in this way a can have only the values about a specific year, but in this case I need to take a single value, and not a sum of values, and

I can't replace input textfield with listbox.

How can I select a single value with only this two object?

Thanks

greend21 — Fri, 10 Nov 2017 15:19:11 GMT

Did you try Num instead of Sum?

vishsaggi — Fri, 10 Nov 2017 15:23:24 GMT

Can you elaborate with some sample data? Textfield you mean textbox or inputfield object?

prieper — Fri, 10 Nov 2017 15:23:27 GMT

Did you ever try to input 2016,2017 for two years?

edit: attached example

Anonymous — Fri, 10 Nov 2017 15:24:23 GMT

I did, but it doesn't work

Anonymous — Fri, 10 Nov 2017 15:32:19 GMT

A little example attached.

Inside the blue box I would read the price about the year that I wrote inside the inputfield

vishsaggi — Fri, 10 Nov 2017 15:37:17 GMT

Try this in your blue box?

= Only( {< year = {$(vYearIn)} >} price)

Anonymous — Fri, 10 Nov 2017 15:48:04 GMT

Thanks