Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bobby_chowdary
New Contributor III

Slope values in povit

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

in1.PNG

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:in3.PNG

$B$2:$N$2:

in4.PNG

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

in2.PNG

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

1 Reply
bobby_chowdary
New Contributor III

Re: Slope values in povit

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