topic Re: Newbie Question in QlikView

Newbie Question

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

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

Re: Newbie Question

passionate — Sat, 14 Apr 2018 06:36:22 GMT

This is not a proper database design.

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

Do you maintain Mapping

Re: Newbie Question

Anonymous — Sat, 14 Apr 2018 06:50:47 GMT

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

Re: Newbie Question

Anonymous — Sat, 14 Apr 2018 07:01:17 GMT

I guess he's just learning. Experimenting.

Re: Newbie Question

Anonymous — Sat, 14 Apr 2018 07:42:10 GMT

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

Re: Newbie Question

passionate — Sat, 14 Apr 2018 15:41:12 GMT

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/Hierarchy.htm

Re: Newbie Question

passionate — Sat, 14 Apr 2018 15:48:59 GMT

Here you go
PFA, Solution.

Re: Newbie Question

MarcoWedel — Sat, 14 Apr 2018 21:28:07 GMT

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

Re: Newbie Question

passionate — Sun, 15 Apr 2018 05:21:14 GMT

Please close the thread if your query is resolved

Re: Newbie Question

Anonymous — Sun, 15 Apr 2018 14:43:58 GMT

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.

Re: Newbie Question

MarcoWedel — Sun, 15 Apr 2018 19:47:40 GMT

Hi,

just follow these steps:

you can create this group on the dimensions tab of some chart properties:

hope this helps

regards

Marco

Re: Newbie Question

MarcoWedel — Sun, 15 Apr 2018 21:16:10 GMT

Glad you like this solution.

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco