topic Need Product Category Dashboard Help in QlikView

Need Product Category Dashboard Help

jaspsing — Fri, 17 Feb 2012 09:04:16 GMT

Hello There,

help me creating dashboard for nth level of category for product.

I have 3 tables.

1 product table: categoryid,productid, productname.

2. categorytable: categoryid, categoryname,parentid

3. Sale: productid, qty, amount,date

Now I need to show like this:

Electronics--> Computers--> Pendrive

Sale Data

How to to that.

Need Product Category Dashboard Help

CELAMBARASAN — Fri, 17 Feb 2012 09:24:26 GMT

Hi,

Where you have to show like this?.You mean on selection?

Celambarasan

Need Product Category Dashboard Help

jaspsing — Fri, 17 Feb 2012 09:38:00 GMT

Thanks for your attention and reply.

I need to show List Box of First level Category, You can take example of one shopping site ebay , flipkart any. I want to show the top category to lower category drill down sales graph.

Now hope you can have correct idea.

Re: Need Product Category Dashboard Help

Anonymous — Fri, 17 Feb 2012 09:41:15 GMT

I have attached one qv file based on your first request.

See this attached file and let me know your clear requirement

Regards

Ashok

Re: Need Product Category Dashboard Help

CELAMBARASAN — Fri, 17 Feb 2012 09:45:13 GMT

Hi,

Create a drill down group for this fileds.then create a list box with that drilldown group as expression.

=DrillDownGroup

Hope it helps

Celambarasan

Need Product Category Dashboard Help

jaspsing — Fri, 17 Feb 2012 11:12:56 GMT

CategoryId	CategoryName	ParentId
1	Electronics
2	Accessories
3	Food
4	Home & Kitchen
5	Fans	13
6	Computers	1
7	Pen Drives	6
8	Mobiles	1
9	Camera	1
10	Clothes	2
11	Jeans	10
12	T-shirts	10
13	Home Appliances	4
14	Kitchen Appliances	4
15	Namkeens	3
16	Biscuits	3

How to Create Drill Down of Category Name till product Name

CategoryId	ProductId	ProductName
7	1	Kingston 2 Gb
8	2	Nokia Lumia
9	3	Canon 100
15	4	Namkeen Mixture
16	5	Butter Bite
5	6	Bajaj ceiling fan-100