Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This is not a proper database design.
How do you define Car should have only BMW and Ford.
Do you maintain Mapping
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
I guess he's just learning. Experimenting.
Thanks for the comments, the data is an example of what i am seeing. Thanks for samole application, will check it out in abit.
I think i got your Question.
you can use hierarchy function in Qlikview
Here you go
PFA, Solution.
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
Please close the thread if your query is resolved
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.