topic Re: show a value in a text box in QlikView

show a value in a text box

sylvain_piccarreta — Fri, 08 Oct 2021 07:56:27 GMT

Hello,

I would like to show in a text box a specific value.
I have a table :

A in a text box, I would like to have 'Sugar : 234 ' even if I selected other thing.

Thanks for your help,

Regards,

Sylvain

sergio0592 — Fri, 08 Oct 2021 08:17:40 GMT

Hi,

If yout try with:

=sum({<Items={'Sugar'}>} Number)

sylvain_piccarreta — Fri, 08 Oct 2021 08:29:00 GMT

thanks for your help but my example was not clear, because, it's not a quantity but it's an ID with some alphanumeric.

sergio0592 — Fri, 08 Oct 2021 08:34:19 GMT

Ok, try with:

=Only({<Items={'Sugar'}>} Number)

sylvain_piccarreta — Fri, 08 Oct 2021 08:39:37 GMT

thanks, it's great