Discussion Board for collaboration on QlikView Scripting.
i have data and i need filter wise data i couldn't find out.
my requirement is i want out put like from each brand i need perteculer product.
Only selected products for brand wise
Ex: Brand Product
Samsung Colour Television
Samsung Washing Machine
Onida Colour Television
LG Washing Machine
Kenstar Colour Television
Sansui Colour Television
Daikin Air Cooler
Kelvinator Washing Machine
if i given the condition all product column will change, attaching sample file.
can anybody give suggestion
Go to Solution.
you need to do it for all the others.
what exactly you are looking for Each brand you want top nos ?
you can take list box and add brand in list box when user select particular brand only that will display in report see attached qvw.
Put your brand in one list box and Product into other list box..
as a selection indicator..then you can select any brand as per ur requirement
i want this report in Pivot Table
Thanks for Reply!
my report not like this, i don't want in list boxes. i need this report in pivot table.
Create a drilling of your Brand and Product Dimension
How could i do for drilling ?
Goto Dimension tab
Click on Edit Groupson the Bottom left side then create a drill group of your dimension.
Give a name of Group say Product_Brand Drilling and add your dimension as in your case
and then use your created group say Product Brand Drilling as a dimension in your pivot table