Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi,
You have a mapping issue in your data. Please provide the sample correct data
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 |
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.
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
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.