Discussion Board for collaboration related to QlikView App Development.
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
How to to that.
Where you have to show like this?.You mean on selection?
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.
I have attached one qv file based on your first request.
See this attached file and let me know your clear requirement
Create a drill down group for this fileds.then create a list box with that drilldown group as expression.
Hope it helps
How to Create Drill Down of Category Name till product Name