topic Find Largest Value In Category And Subcategory in QlikView

Find Largest Value In Category And Subcategory

Fri, 28 Aug 2015 05:42:45 GMT

hello dears

i want find largest value in Category And Subcategory then data is filter (Create New Dimension Of Largest SaleAmount)

i want show table that include highest value Per Subcatgory (i want show Category,Subcategory,Highest Value ,each category have multiple Subcategory)

For example :

Bike-->Road Bikes -->14520584

Accessories-->Tires And Tubes -->245529

plz help me

file is attach

Re: Find Largest Value In Category And Subcategory

crusader_ — Fri, 28 Aug 2015 06:51:49 GMT

Hi,

Please explain why the table on the right is not "right"?

Also, please show your expected result in simple table (Excel). It helps others correctly understand your requirements.

Thanks in advance.

Regards,

Andrei

Re: Find Largest Value In Category And Subcategory

Fri, 28 Aug 2015 07:02:08 GMT

Look like

Re: Find Largest Value In Category And Subcategory

tresB — Fri, 28 Aug 2015 07:17:55 GMT

PFA

Re: Find Largest Value In Category And Subcategory

crusader_ — Fri, 28 Aug 2015 07:18:44 GMT

You need to change expression a bit.

PFA example.

Regards,

Andrei

Re: Find Largest Value In Category And Subcategory

Fri, 28 Aug 2015 07:38:30 GMT

Thanks But is not valid

for example : Bike-->Road Bikes In highest No mountain bikes

Re: Find Largest Value In Category And Subcategory

crusader_ — Fri, 28 Aug 2015 07:42:05 GMT

Then use tresesco‌ approach.

Regards,

Andrei

Re: Find Largest Value In Category And Subcategory

kavita25 — Fri, 28 Aug 2015 08:01:15 GMT

Check the qvw

In calculated dimension use the below logic:

=If(Aggr(Rank(Aggr(Sum(SalesAmount), EnglishProductCategoryName, EnglishProductSubcategoryName)), EnglishProductCategoryName, EnglishProductSubcategoryName) <= 1,

EnglishProductSubcategoryName)

Regards,

Kavita