Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

masheleceda
New Contributor

How to display A number for status FWK into a Textbox

display.PNG

Good Day
Please help
How to display number for status FWK into a Textbox
please see the screen dump below

1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: How to display A number for status FWK into a Textbox

Is your jobs field an expression or a dimension? Try this?

= Only({<Status = {'FWF'}>}Jobs)

If jobs is an expression you have to use that expr like

= Only({<Status = {'FWF'}>} Yourexprehere)

5 Replies
YoussefBelloum
Esteemed Contributor

Re: How to display A number for status FWK into a Textbox

Hi,

you can use set analysis for this

your_function({<STATUS={'FWK'}>}job)

masheleceda
New Contributor

Re: How to display A number for status FWK into a Textbox

Hi , it is NOT working may you please send me an example.

vishsaggi
Esteemed Contributor III

Re: How to display A number for status FWK into a Textbox

Is your jobs field an expression or a dimension? Try this?

= Only({<Status = {'FWF'}>}Jobs)

If jobs is an expression you have to use that expr like

= Only({<Status = {'FWF'}>} Yourexprehere)

masheleceda
New Contributor

Re: How to display A number for status FWK into a Textbox

Thank you very much you are a star

masheleceda
New Contributor

Re: How to display A number for status FWK into a Textbox

Thank you very much you are a star, it is working super fine