Newbie Question

[Anonymous]

Hello All,

I need some help with my first QV application and rather new

Datatable looks like this

H1	H2	H3
1	0	Car
2	1	BMW
3	1	Ford
4	0	House
5	4	Terrace
6	4	Detached

I want my sheet to have a list showing

Header 1
Car
House

Then based on the selection either Car or House to show another list

Car:

Header 1
BMW
Ford

House:

Header 1
Terrace
Detached

how would I accomplish something like that

Thanks in advance for your support.

Mac

[passionate]

This is not a proper database design.

How do you define Car should have only BMW and Ford.

Do you maintain Mapping

[Anonymous]

Attached is a simple  workaround. Put this up just to show you it is possible. It uses the following concepts:

1. Conditional Layout

2. Listbox with expressions

3. Multiple Alternate states

-Benazir

[Anonymous]

I guess he's just learning. Experimenting.

[Anonymous]

Thanks for the comments, the data is an example of what i am seeing. Thanks for samole application, will check it out in abit.

[passionate]

I think i got your Question.

you can use hierarchy function in Qlikview

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

[passionate]

Here you go
PFA, Solution.

[MarcoWedel]

Hi,

maybe you could use a tree view list box or a drill down list box to achieve your required result:

table1:
Hierarchy (H1,H2,H3,,H3,'Path')
LOAD H1,
    H2,
    H3
FROM [https://community.qlik.com/thread/298208] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco

[passionate]

Please close the thread if your query is resolved

[Anonymous]

Thanks for the responses, but because I have a personal edition I cannot open your guys applications. Any ideas how I may be able to do that? appreciate your help on this.