topic inline table in QlikView

inline table

Wed, 25 Nov 2020 16:16:04 GMT

i have 2 companies named QWERTY, ASDFG

in qwerty i have regions like bangalore, cochin, abc, def

in asdfg i have regions like abcs, xyz, mnc, defs

i have a inline table like

load * inline

[

Incident zone, name

1, bangalore

2, cochin

3, abc

4, def

3s, abcs

5, xyz

6, mnc

4s, defs

];

and one more

Load* inline [

columnname, name, sheetname

qwerty , 1 , qwerty

asdfg , 2 , asdfg

Combined , 3 , both

];

so in dashboard i created a list box with fields

qwerty

asdfg

combined

so when i click on qwerty i should get only bangalore, cochin, abc, def in another list box

and when i click on asdfg i should get only abcs, xyz, mnc, defs

and when i click on combined i should get all the names in the list box.

so please help me as new to qlik.

Re: inline table

jonathandienst — Tue, 22 Nov 2016 05:16:28 GMT

First of all - there is no association between the companies and the zone names or regions. You need to create the associations before you can work meaningfully with this data model. Once that is in place, selecting a company will filter the region list box to the relevant regions.

Rather than creating a value of combined, consider no selection as "combined". This the normal QV design pattern and behaviour. If for some reason you absolutely must have a combined option in the list, you will need to add "Combined" to the "Region" associations.

Re: inline table

dineshm030 — Tue, 22 Nov 2016 05:30:29 GMT

Hi,

You have a mapping issue in your data. Please provide the sample correct data

Re: inline table

ramasaisaksoft — Tue, 22 Nov 2016 05:35:34 GMT

Hi Sona,

you can create only one Inline table

load * inline

[

Incident zone, name,columnName

1, bangalore	qwerty
2, cochin	qwerty
3, abc	qwerty
4, def	qwerty
3s, abcs	asdfg
5, xyz	asdfg
6, mnc	asdfg
4s, defs	asdfg
1, bangalore	combined
2, cochin	combined
3, abc	combined
4, def	combined
3s, abcs	combined
5, xyz	combined
6, mnc	combined
4s, defs	combined

Re: inline table

dineshm030 — Tue, 22 Nov 2016 05:51:24 GMT

Hi Sona,

I think you want like this result. Attached QVW file is for your reference.

I have used two inline tables. Just go throw it.

I hope this helps.

Re: inline table

hemanthaanichet — Tue, 22 Nov 2016 06:21:27 GMT

Hi Sona,

There is no association between the companies and the zone names or regions. so u may have issue in get the desired results.

I make some changes in your data and worked on that

As per your requirement i showed it in the list box

i think this may helps you

attached the qvw for your reference

Regards

Hemanth

Re: inline table

MK9885 — Tue, 22 Nov 2016 13:09:21 GMT

When you select QWERTY, it will only show you Banglore as the Name field in both the tables are common as 1 for Banglore. But for Cochin, your Name field value is 2 in 2nd Inline, hence it will not show you Cochin.

Map the fields and values correctly so that you'll get a proper selection.

Thanks.