topic Re: Need help in Pivot table in QlikView

Need help in Pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have create pivot table seller name,quarter as dimension and sales amount as expression.

How can i create pivot table with column %QoQ and Trend as shown in the picture.

Thanks for advance..

Re: Need help in Pivot table

prma7799 — Thu, 22 Jun 2017 07:32:31 GMT

What is your %QoQ Logic based on logic you can create that %QoQ column and after creation of %QoQ simply create new column like

if( %QoQ < 0 , 'Decline' , 'Growth')

Re: Need help in Pivot table

Anonymous — Thu, 22 Jun 2017 07:40:10 GMT

Logic for- %QoQ is (Current quarter-Previous quarter)/Previous quarter. If i add column in pivot it will show for all expression. I need end of the pivot.

Re: Need help in Pivot table

prma7799 — Thu, 22 Jun 2017 07:47:05 GMT

You want like this?

Try below expression

(( ((SUM({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear))}
,[Posting Date]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date])))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}
>}[Sales Amount])/100000))-

((Sum({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)}
,[Posting Date]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-4))<=$(=Monthend(addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12)))"}
>} [Sales Amount])

)/100000))/

fabs(((Sum({$<FinancialYear=,Quarter=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)}
,[Posting Date]={">=$(=QuarterStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-4))<=$(=Monthend(addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12)))"}
>} [Sales Amount])

)/100000)))*100

Or Please share some sample app

Re: Need help in Pivot table

Anonymous — Thu, 22 Jun 2017 07:48:31 GMT

Yes.. correct.