topic Re: Pivot chart displaying of particular number of dimensions in QlikView

Pivot chart displaying of particular number of dimensions

rohitians — Mon, 01 Jul 2013 04:43:05 GMT

Hello,

I have this pivot table where in i have Companies with their brand names ,I am diplaying sales of this brands CYvsLY..

Now the scene is i want to show only a particular number of brands i.e input box the user may select i want to see only top 3 brands of all companies

so as per the number only 3 top selling brands should be displayed for each company and total sales for that company should be dispayed...

I am attaching a sample qvw file in order to get an idea of the report...

and is it possible to achieve the same...

Thanks and Regards,

Rohit

Re: Pivot chart displaying of particular number of dimensions

Mon, 01 Jul 2013 05:38:40 GMT

Please check the attached app and confirm whether it satisfies your requirement

Re: Pivot chart displaying of particular number of dimensions

rohitians — Mon, 01 Jul 2013 06:11:54 GMT

Hello Vikram,

It's actually what i wanted...

But only one problem suppose i choose 10 it shows 10 brands and shows total of all the rest brands but with no label it shows - ..else everything is bang on..

Hope you are doing good..

Thanks and Regards,

Rohit

Re: Pivot chart displaying of particular number of dimensions

tresB — Mon, 01 Jul 2013 06:23:30 GMT

Are you looking for this?

Re: Pivot chart displaying of particular number of dimensions

rohitians — Mon, 01 Jul 2013 07:08:07 GMT

No tresesco,

Go through app posted by Mr Vikram you would to kno what I am asking...

Thanks and Regards,

Rohit

Re: Pivot chart displaying of particular number of dimensions

rohitians — Mon, 01 Jul 2013 09:40:52 GMT

Hey Jatin

When I want to use a cyclical group instead of a single field company and the following is the code,

=if(aggr (rank (SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))},

Date={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>} Date),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>} Date))"}>}Values

/10000000)

),GetCurrentField(Co-Thr),BRAND)<=$(vTopBrands),BRAND)

Is this the right way,

Thanks and Regards,

Rohit

Re: Pivot chart displaying of particular number of dimensions

Mon, 01 Jul 2013 10:18:59 GMT

Hi Rohit ,

try something this

=if(GetCurrentField(New)='COMPANY',

if(aggr(rank(sum(CY)),COMPANY,BRAND)<=$(Top),BRAND)

,if(GetCurrentField(New)='BRAND',

if(aggr(rank(sum(CY)),BRAND,BRAND)<=$(Top),BRAND)))

New --- Name of Cyclic group dimesnion

Re: Pivot chart displaying of particular number of dimensions

Mon, 01 Jul 2013 10:39:37 GMT

TRY THIS,

=if(aggr(rank(sum(CY)),

$(=if(GetCurrentField("cc_grp") = 'COMPANY', 'COMPANY',

if(GetCurrentField("cc_grp") = 'COMPANY1', 'COMPANY1',

if(GetCurrentField("cc_grp") = 'COMPANY11', 'COMPANY11'

))))

,BRAND)<=$(Top),BRAND)

Re: Pivot chart displaying of particular number of dimensions

Mon, 01 Jul 2013 10:40:55 GMT

=if(aggr(rank(sum(CY)),$(=GetCurrentField(New)),BRAND)<=$(Top),BRAND)

Re: Pivot chart displaying of particular number of dimensions

rohitians — Tue, 02 Jul 2013 06:10:21 GMT

Hello Vikram, Jatin

Thanks for helping

=if(aggr(rank(sum(CY)),$(=GetCurrentField(New)),BRAND)<=$(Top),BRAND)

this code is working...

Thanks and Regards,

Rohit