Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Text box

Hi All,

Plz help me to get clear of this,

Thanks in Advance.

I have fields like

cat1.code,cat1,cat2.code,cat2,cat3.code,cat3,cat4.code,cat4

10337,Ice cream,9324,Gallons,11385,Premium IC Gallaons,253,Choclate gallon

9319,Seafood,11374,Fish,9320,Fish Breaded,547,Parfried Breaded  Haddock Sticks

,

,

.

so on

Here my requirement is if i select the code of any it has to show the related cat name in text box and viseversa.

8 Replies
Partner
Partner

Hi Datha,

do you have a simple example QVW that you can upload to the Community?:

Best regards,

Andy

Specialist II
Specialist II

Hi

Your requirement is not clear. Give one example with input and output. Or else upload sample data

Master II
Master II

put into the textbox a formula like

= ONLY(cat1)

resp.

= ONLY([cat1.code])

This will show the corresponding values, if just one value is available.

Peter

Please let us know which is ur filter ?

and what value you will select in that filter ?

and what value you want to see in text box ?as a  output.

if you share your query clearly then we will help you on output.

Specialist II
Specialist II

You can create two text boxes with Category code and Category Name. When you select any Category code in list box then corresponding values will get in Text boxes accordingly.

=Only(Category Code) or =(Category Code)

=Only(Category Name) or =(Category Name)

Hope it helps!!

Creator
Creator

Hi ,

As per my requirement i am adding the list boxes for category name and for category codes.i want to show the selection in the text box as if i select the category name in the list box it has to display the category code in text box,if i select the category code in the list box it has to show the category name in the text box.

Master II
Master II

please post an example along with the required behaviour

Partner
Partner

Hi Datha,

please check the simple example as a starting point, to see if this is what you want.

Andy