Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
khasimvali85
Creator II
Creator 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.

17 Replies
Anonymous
Not applicable

Please see the attachment.

Hope this will help!!

khasimvali85
Creator II
Creator II
Author

Hi Balraj,

This report will show only Brand wise and all product wise

my report is given like

i need to selected products for brand and i don't want all products for brand

      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

Anonymous
Not applicable

  This is the data you are having in your QV, rite?

Then how do you want to present it?

or in the same way you want to represent???

vikasmahajan

you can use drop down select see attached file

HTH

vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
khasimvali85
Creator II
Creator II
Author

Hi Vikas,

If we do drop down the all data will change.

please see the new attached QVW file for my output.

Anonymous
Not applicable

For this you need to hard code it..

Like you can add a calculated dimension like

If(Brand='DAikin', if(Product='Air Cooler' or Product='LCD', Product),

if(Brand.......like this...

Anonymous
Not applicable

PFA..

you need to do it for all the others.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

LOAD BRAND,

     PRODUCT,

     Value,

     If(WildMatch(BRAND, 'Samsung') AND WildMatch(PRODUCT, 'Colour Television', 'Refrigerator', 'Washing Machine') OR

     WildMatch(BRAND, 'Onida') AND WildMatch(PRODUCT, 'Colour Television', 'LCD') OR

     WildMatch(BRAND, 'LG') AND WildMatch(PRODUCT, 'Refrigerator', 'Washing Machine') OR

     WildMatch(BRAND, 'Kenstar') AND WildMatch(PRODUCT, 'Colour Television', 'LCDP') OR

     WildMatch(BRAND, 'Sansui') AND WildMatch(PRODUCT, 'Colour Television', 'Refrigerator', 'LCD') OR

     WildMatch(BRAND, 'Daikin') AND WildMatch(PRODUCT, 'Air Cooler', 'LCD') OR

     WildMatch(BRAND, 'Kelvinator') AND WildMatch(PRODUCT, 'Washing Machine', 'Refrigerator'), 1, 0) AS Flag    

FROM

BRAND_PRODUCT.xls

(biff, embedded labels, table is [Sheet1$]);

Now in front use below expression

SUM({<Flag={1}>}Value)

Hope this helps you.

Regards,

Jagan.