topic Re: Is This Possible? in QlikView

Is This Possible?

Fri, 25 Oct 2013 11:01:52 GMT

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 .

Re: Is This Possible?

DavidFoster1 — Fri, 25 Oct 2013 11:12:00 GMT

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

Re: Is This Possible?

Fri, 25 Oct 2013 11:20:12 GMT

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 ?

Re: Is This Possible?

sujeetsingh — Fri, 25 Oct 2013 11:20:28 GMT

Better go with image and assign triggers if possible.

Re: Is This Possible?

Fri, 25 Oct 2013 11:22:59 GMT

Thanks.

Any suggestions then?

Re: Is This Possible?

swuehl — Fri, 25 Oct 2013 11:23:18 GMT

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.

Re: Is This Possible?

Fri, 25 Oct 2013 11:23:36 GMT

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