Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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