Is This Possible?

[#1]

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 .

[DavidFoster1]

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

[#3]

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]

Better go with image and assign triggers if possible.

[#5]

Thanks.

Any suggestions then?

[swuehl · Accepted solution]

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.

[#7]

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