Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

jaspsing
New Contributor II

Need Product Category Dashboard Help

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.

5 Replies

Need Product Category Dashboard Help

Hi,

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

Celambarasan

jaspsing
New Contributor II

Need Product Category Dashboard Help

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.

chandashok
Contributor III

Re: Need Product Category Dashboard Help

Hi

     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

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

Highlighted
jaspsing
New Contributor II

Need Product Category Dashboard Help

CategoryIdCategoryNameParentId
1Electronics
2Accessories
3Food
4Home & Kitchen
5Fans13
6Computers1
7Pen Drives6
8Mobiles1
9Camera1
10Clothes2
11Jeans10
12T-shirts10
13Home Appliances4
14Kitchen Appliances4
15Namkeens3
16Biscuits3


How to Create Drill Down of Category Name till product Name

CategoryId

ProductId

ProductName

71 Kingston 2 Gb
8 2 Nokia Lumia
9Canon 100
154 Namkeen Mixture
165 Butter Bite
5Bajaj ceiling fan-100