Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

khasimvali85
Contributor II

Need Dimension wise filter results

Dear Community,

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      Refrigerator

    Samsung      Washing Machine

    Onida            Colour Television

    Onida            LCD

    LG                Refrigerator

    LG                Washing Machine

    Kenstar        Colour Television

    Kenstar        LCDP

    Sansui          Colour Television

    Sansui         Refrigerator

    Sansui         LCD

    Daikin          Air Cooler

    Daikin          LCD

    Kelvinator    Refrigerator

    Kelvinator   Washing Machine

if i given the condition all product column will change, attaching sample file.

can anybody give suggestion

Regards,

Khasim.

1 Solution

Accepted Solutions
balrajahlawat
Esteemed Contributor

Re: Need Dimension wise filter results

PFA..

you need to do it for all the others.

17 Replies
vikasmahajan
Honored Contributor III

Re: Need Dimension wise filter results

what exactly you are looking for  Each brand you want top nos ?

vikasmahajan
Honored Contributor III

Re: Need Dimension wise filter results

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.

Vikas

balrajahlawat
Esteemed Contributor

Re: Need Dimension wise filter results

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

khasimvali85
Contributor II

Re: Need Dimension wise filter results

Hi Vikas,

i want this report in Pivot Table

Regards,

Khasim.

khasimvali85
Contributor II

Re: Need Dimension wise filter results

Hi Balraj,

Thanks for Reply!

my report not like this, i don't want  in list boxes. i need this report in pivot table.

balrajahlawat
Esteemed Contributor

Re: Need Dimension wise filter results

Create a drilling of your Brand and Product Dimension

khasimvali85
Contributor II

Re: Need Dimension wise filter results

Hi,

How could i do for drilling ?

balrajahlawat
Esteemed Contributor

Re: Need Dimension wise filter results

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

Brand

Product

like this..

balrajahlawat
Esteemed Contributor

Re: Need Dimension wise filter results

and then use your created group say Product Brand Drilling as a dimension in your pivot table

Community Browser