Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
swuehl
MVP
MVP

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.

View solution in original post

6 Replies
DavidFoster1
Specialist
Specialist

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

product listbox.png

Not applicable
Author

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
Master III
Master III

Better go with image and assign triggers if possible.

Not applicable
Author

Thanks.

Any suggestions then?

swuehl
MVP
MVP

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
Author

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