topic Re: Combo chart help required?? in QlikView

Combo chart help required??

rohitians — Mon, 11 Nov 2013 10:00:19 GMT

Hello,

I have a combo chart where in net sales division wise is displayed ....i want to display top 5 division sales contribution to total sales in a text box...

Following is the expression for sales...

(SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}>}[Gross Sales Amount])

SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}>}[Sales Return Amount])

)

/100000

Thanks and Regards,

Rohit Yadav

Message was edited by: Rohit Yadav

Re: Combo chart help required??

kaushiknsolanki — Mon, 11 Nov 2013 10:04:55 GMT

Hi,

Kindly send the qvw file.

Regards,

Kaushik Solanki

Re: Combo chart help required??

kaushalview — Mon, 11 Nov 2013 10:16:16 GMT

Hi,

If you want to dispaly top 5 division sales then use rank function with aggr of based on Field u want to sort.

Regards

Kaushal Mehta

Re: Combo chart help required??

rohitians — Mon, 11 Nov 2013 10:17:41 GMT

No i want is percentage of sum of sales of top 5 divisions contribution to the total sales of company...

Re: Combo chart help required??

rohitians — Tue, 12 Nov 2013 04:50:35 GMT

Hey do want to say in this manner,

=AGGR(IF(RANK((SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}>}[Gross Sales Amount])

SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}>}[Sales Return Amount])

)

/100000)<=5,Division)

Re: Combo chart help required??

Anonymous — Tue, 12 Nov 2013 05:07:32 GMT

HI ,

Please find attached qvw.

Re: Combo chart help required??

rohitians — Tue, 12 Nov 2013 05:33:45 GMT

Thank You Jatin..