Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dathathreya
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
awhitfield
Partner
Partner

Hi Datha,

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

Best regards,

Andy

qlikviewnovice
Specialist II
Specialist II

Hi

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

prieper
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

ramasaisaksoft

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.

qlikviewnovice
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!!

dathathreya
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.

prieper
Master II
Master II

please post an example along with the required behaviour

awhitfield
Partner
Partner

Hi Datha,

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

Andy