topic Re: Need Dimension wise filter results in QlikView

Need Dimension wise filter results

khasimvali85 — Thu, 10 Sep 2015 05:42:36 GMT

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.

Re: Need Dimension wise filter results

vikasmahajan — Thu, 10 Sep 2015 05:48:53 GMT

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

Re: Need Dimension wise filter results

vikasmahajan — Thu, 10 Sep 2015 05:53:14 GMT

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

Re: Need Dimension wise filter results

Anonymous — Thu, 10 Sep 2015 05:57:14 GMT

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

Re: Need Dimension wise filter results

khasimvali85 — Thu, 10 Sep 2015 05:59:33 GMT

Hi Vikas,

i want this report in Pivot Table

Regards,

Khasim.

Re: Need Dimension wise filter results

khasimvali85 — Thu, 10 Sep 2015 06:01:55 GMT

Hi Balraj,

Thanks for Reply!

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

Re: Need Dimension wise filter results

Anonymous — Thu, 10 Sep 2015 06:02:08 GMT

Create a drilling of your Brand and Product Dimension

Re: Need Dimension wise filter results

khasimvali85 — Thu, 10 Sep 2015 06:04:35 GMT

Hi,

How could i do for drilling ?

Re: Need Dimension wise filter results

Anonymous — Thu, 10 Sep 2015 06:08:36 GMT

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..

Re: Need Dimension wise filter results

Anonymous — Thu, 10 Sep 2015 06:09:35 GMT

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

Re: Need Dimension wise filter results

Anonymous — Thu, 10 Sep 2015 06:12:14 GMT

Please see the attachment.

Hope this will help!!

Re: Need Dimension wise filter results

khasimvali85 — Thu, 10 Sep 2015 06:22:42 GMT

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

Re: Need Dimension wise filter results

Anonymous — Thu, 10 Sep 2015 06:29:57 GMT

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???

Re: Need Dimension wise filter results

vikasmahajan — Thu, 10 Sep 2015 06:35:02 GMT

you can use drop down select see attached file

HTH

vikas

Re: Need Dimension wise filter results

khasimvali85 — Thu, 10 Sep 2015 06:53:35 GMT

Hi Vikas,

If we do drop down the all data will change.

please see the new attached QVW file for my output.

Re: Need Dimension wise filter results

Anonymous — Thu, 10 Sep 2015 07:17:36 GMT

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...

Re: Need Dimension wise filter results

Anonymous — Thu, 10 Sep 2015 07:20:36 GMT

PFA..

you need to do it for all the others.

Re: Need Dimension wise filter results

jagan — Thu, 10 Sep 2015 07:23:42 GMT

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.