topic Re: Static x-axis in QlikView

Static x-axis

Sat, 19 Nov 2016 00:37:25 GMT

In this graph I want to:

1.Calculate percentages:

E.g.if user selects TLName(Khnlrp Bvatfk Evcqbw Aaryktfatg)-->TPName(Helmhbs Guajxel)-->Pcode(N99M214J), then calculate the %utilization(Quantity*100/TotalQuantity of A99D211Z, G99K213M,N99M214J)

in this case(1113*100/20255). Is my calculation correct?

2.Keep the X axis static:

When user selects any TLName or TPName, the X axis should not shrink if it has only 1 PCode to display. The X-axis shoould always display the 3 Pcodes. How can this be done?

Re: Static x-axis

Sat, 19 Nov 2016 14:42:45 GMT

Any inputs? I need some expert help here!

Re: Static x-axis

Sun, 20 Nov 2016 17:16:32 GMT

Please someone help!!!!!!!

Re: Static x-axis

Anonymous — Mon, 21 Nov 2016 05:25:21 GMT

Hi Enthu

If you want static axes go to chart properties-> Axes ->select the Expression you to want make static axes ->scales

set the values max and min that you can as static .

Regards

Mahesh

Re: Static x-axis

tresB — Mon, 21 Nov 2016 05:50:37 GMT

Qlik Enthu wrote:

........

2.Keep the X axis static:

When user selects any TLName or TPName, the X axis should not shrink if it has only 1 PCode to display. The X-axis shoould always display the 3 Pcodes.

If a TPName has only 1 PCode to show, you still want it show 3 PCodes ! Where would the rest two come from?

Re: Static x-axis

Mon, 21 Nov 2016 18:39:13 GMT

Thanks for replying. It did not help.

Re: Static x-axis

Mon, 21 Nov 2016 23:38:02 GMT

Thanks for replying. Is it possible to assign those 3PCodes to the TPName. So if a TPName is selectded, the x axis still shows all 3 codes, but 0% against the 2 codes and the % value against 1 code