Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

miro_kopecky
New Contributor II

one value from field of numbers

Hi
I've got field of numbers and i need to use only one of them in expression...is it possible to filter this number of that field?
Thanks in advance

1 Solution

Accepted Solutions
thiago_justen
Valued Contributor III

Re: one value from field of numbers

Miroslav,

You can filter it into load script just like this:

Load

Your_Fields

From Your_Base Where Number=Your_Number;

If what you want is filter it on user interface, maybe this will help you:

Only({<Number={1}>}Number)

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
3 Replies
thiago_justen
Valued Contributor III

Re: one value from field of numbers

Miroslav,

You can filter it into load script just like this:

Load

Your_Fields

From Your_Base Where Number=Your_Number;

If what you want is filter it on user interface, maybe this will help you:

Only({<Number={1}>}Number)

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago
miro_kopecky
New Contributor II

Re: one value from field of numbers

Thanks, its working but i have another question...These numbers are currency rates from the website which is daily updated. Does it update these numbers in my app too ?

thiago_justen
Valued Contributor III

Re: one value from field of numbers

My solution was not a dynamical one. So, in this case I'd suggest you something like this:

Only ({<Date_Field={$(=today ())}>}Number_Rate)

Then you will get only today's rate.

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago