topic Re: Is it possible to create a template and based on a combo box? in QlikView

Is it possible to create a template and based on a combo box?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I will like to create some fields that will be autopopulated based on a combo box.

For example I will have the following fields:

Name:

Country:

Age:

ID:

Phone:

I will like to have the fields autopopulated based on a combo that may be the ID or name. Is that possible on QlikView? if so, can you please let me know how?

Thanks in advanced for your help.

Re: Is it possible to create a template and based on a combo box?

Wed, 27 Jul 2016 19:01:21 GMT

Hello Roberto,

Please tell me if attached app is what you are looking for

Images:

1) First selection:

2) Second selection:

BR,

Kuba

Re: Is it possible to create a template and based on a combo box?

Anonymous — Thu, 28 Jul 2016 13:07:21 GMT

Yes, that is what I need, how do you do that? Please use as much details as you can.

Re: Is it possible to create a template and based on a combo box?

Thu, 28 Jul 2016 15:44:58 GMT

Hello Roberto,

I've attached a qvw file for you. Everything is there

If you can't open it, because of personal license, here is how I did it step by step.

Script:

LOAD * INLINE [

Name, Country, Age, ID, Phone

Mark, Poland, 17, 1, 444444444

Thomas, Poland, 5, 2, 888888888

Luigi, Germany, 45, 3, 875412369

];

Drop down:

- It is a simple Multi box, with one Field added (ID)

Area with information:

- That is just a slightly modified text box, with below code pasted as its Text:

='ID: ' & ID &Chr(10)&
'Name: ' & Name&Chr(10)&
'Country: ' & Country&Chr(10)&
'Age: ' & Age&Chr(10)&
'Phone: ' & Phone&Chr(10)&

Hope it helps.

BR,

Kuba

Re: Is it possible to create a template and based on a combo box?

Anonymous — Thu, 28 Jul 2016 18:14:32 GMT

Ok, great and thank you for your time. How does this works if the data comes from a database? what should change in the code?

Re: Is it possible to create a template and based on a combo box?

Thu, 28 Jul 2016 21:04:03 GMT

Data source does not matter (you must only make sure that values from database have same label)

So in general you would need to change script only (instead on inline load, create db connection string, and then data load from db)

If you do not know how to do it, please go here: QlikView 11 Developer Tutorial

Maybe start with this: https://www.youtube.com/watch?v=DTp7nrcI6G0

BR,

Kuba

Re: Is it possible to create a template and based on a combo box?

Anonymous — Fri, 29 Jul 2016 17:17:39 GMT

Great!!!!!, It's working as you said!!!!!

Now, if you have more than 1 record that share the same field as country, that you can add 2 text box with the same data based on country?

In your example you have Poland and Germany, if you select Poland how can I display the 2 options populated?

I mean that you will see:

ID: 1 ID:2

Name: mark Name: Thomas

Country: Poland Country: Poland

Age: 17 Age: 5

Phone: 4444444 Phone: 8888888

When the country filter is Poland

Re: Is it possible to create a template and based on a combo box?

Sat, 30 Jul 2016 17:55:42 GMT

Hey Roberto,

My initial solution assumes only 1 possibile Id selected at time, thus what you have described is not possible in my file.

Can you share the use case with me? Maybe we are overthinking it

Re: Is it possible to create a template and based on a combo box?

Anonymous — Mon, 01 Aug 2016 12:49:16 GMT

This is for a project that I am working, I just trying to figure it out if it's possible or not. I have an integration between SQL, Excel and Word, so my Excel will bring all the tickets by product that accomplish a query, then when I opened the word template it will display all the records in the template. If I only have 1 it will bring 1 template, if I have 2 it will bring 2 templates (in the same word file). I don't know how this was created.

So, In QlikView I will like to filter by Product and if there are 2 records then that one template will be filled out with the information from first record and the second one with the information of the second record.

As now, with the information that you provided I have already created a filter that will fill the template base on the selection, but I will like to know if display all the records for the same product will be possible.

Thanks in advanced for your help.