Slope values in povit

Anonymous — Tue, 05 Apr 2016 07:11:26 GMT

hi team,

Can you share how to create slope values in pivot table?

in that pivot table have drill down option and when i was going to drill down i need related value on selected fields.

Ex:if i select country then i want related to country values

like bellow

in above screen shot slope is derived by;

=IFERROR(IF(OR(ISBLANK(A3),SUM(B3:N3)=0),"",IF(SLOPE(B3:N3,DATEVALUE($B$2:$N$2))>0,5,IF(SLOPE(B3:N3,DATEVALUE($B$2:$N$2))<0,6,""))),"")

A3=india

B3:N3:

$B$2:$N$2:

Slope Values is derived by:

=SLOPE(B3:N3,DATEVALUE($B$2:$N$2))

and when i was going to dril down i need state values like

here column level i am using Country and State

Row level Date

Metric:sum(People)

like above thing i need to replicate same in Qlik view

Could you pleas share how to replicate in Qlik view.

Note:

in column level now i have Country and State let us assume if i have Country,State,city,Dist

Regards,

Boby

Re: Slope values in povit

Anonymous — Wed, 13 Apr 2016 11:40:23 GMT

Hi team,

i hope till now i am not getting one reply means is it not possible ?

any way i am adding QVw file let any one please suggest the best possible ways

Let me know if any information required for this i will provide

Reagrds,

Boby