Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Is This Possible?

Hi All

I have been searching for the option through which I can get a Dashboard like the one attached here. I want you to fucus on getting the Product categories(Kitchen,Home Interior,Gadgets) under Product (not adjacent to it) and futher things in product categories under  it .

1 Solution

Accepted Solutions
MVP
MVP

Re: Is This Possible?

Maybe like attached, using a pivot table in indent mode.

Or look into something like described here:

How to Create a Profit and Loss Statement in QlikView

edit:

Missed that you are using PE, so here is what I did:

Script:

LOAD * INLINE [

Product Group, Product, Description

Kitchen, Spoon, Steel

Kitchen, Cooker, Hot

Kitchen, Plate, Steel

Kitchen, Knife, Sharp

Gadgets, Mouse, Tiny

Gadgets, Keyboard, Keys

Gadgets, Monitor, Large

];

to load some sample data.

Then create a pivot table with dimensions, Product Group and Product.

Use

=if(Dimensionality()>1,only(Description),' ')

as expression.

Use indent mode on style tab and 'subtotals on top' on presentation tab.

6 Replies
dfoster9
Valued Contributor

Re: Is This Possible?

One option would be to use the treeview option in the listbox object.

product listbox.png

Not applicable

Re: Is This Possible?

David Foster

Thanks

I am using a personal edition so I am unable to open the attached file .Also I want to use this in a pivot table .Not in list box ,If that is possible ?

sujeetsingh
Honored Contributor III

Re: Is This Possible?

Better go with image and assign triggers if possible.

Not applicable

Re: Is This Possible?

Thanks.

Any suggestions then?

MVP
MVP

Re: Is This Possible?

Maybe like attached, using a pivot table in indent mode.

Or look into something like described here:

How to Create a Profit and Loss Statement in QlikView

edit:

Missed that you are using PE, so here is what I did:

Script:

LOAD * INLINE [

Product Group, Product, Description

Kitchen, Spoon, Steel

Kitchen, Cooker, Hot

Kitchen, Plate, Steel

Kitchen, Knife, Sharp

Gadgets, Mouse, Tiny

Gadgets, Keyboard, Keys

Gadgets, Monitor, Large

];

to load some sample data.

Then create a pivot table with dimensions, Product Group and Product.

Use

=if(Dimensionality()>1,only(Description),' ')

as expression.

Use indent mode on style tab and 'subtotals on top' on presentation tab.

Not applicable

Re: Is This Possible?

I am new to qv so can you please elaborate over it?

Community Browser