Slope values in povit

[Anonymous]

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

[Anonymous]

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