topic Re: Reference line to be always displayed - Static Min Doesnt Work. in QlikView

Reference line to be always displayed - Static Min Doesnt Work.

retko1985 — Thu, 02 Nov 2017 17:21:09 GMT

Hello,

please refer to example app in attachment.

I Set a reference line, which I want to have always displayed. If the Amount is Above the reference line, it should scale to that amount, like this:

This is OK.

But when I make a selection where every amount is substantially below the amount of reference line, the line disappears (it is not scaled to the amount of reference line).:

What I tried to do, is to set static min for the amount of reference line, which is 40 here, si the static min is =40.

So the point is, that I need reference line to be always displayed.

Thank you for help.

Re: Reference line to be always displayed - Static Min Doesnt Work.

sunny_talwar — Thu, 02 Nov 2017 17:47:38 GMT

Did you mean to set Static Max?

Re: Reference line to be always displayed - Static Min Doesnt Work.

Anonymous — Thu, 02 Nov 2017 19:26:22 GMT

See attachment.

=rangemax(45,max(aggr(sum(Amount),ID))) in Static Max field.

Re: Reference line to be always displayed - Static Min Doesnt Work.

vishsaggi — Thu, 02 Nov 2017 19:56:36 GMT

May be increase your scale is one way try below.

Re: Reference line to be always displayed - Static Min Doesnt Work.

retko1985 — Fri, 03 Nov 2017 08:56:33 GMT

When I select All values, bar for ID 6 is not going all the way to 300:

Re: Reference line to be always displayed - Static Min Doesnt Work.

jonathandienst — Fri, 03 Nov 2017 09:14:50 GMT

Use the suggestion above from atkinsow

Re: Reference line to be always displayed - Static Min Doesnt Work.

retko1985 — Fri, 03 Nov 2017 11:11:46 GMT

Thank you Wallo, but, I just find this solution too complex for my basic need. Because I already have my sum too complex with checking several conditions and also with aggr and all that stuff. Now My chart has several changing dimension based on conditions and I will need to do aggr for each different dimension. Well the point is, not quite usable for complexity.

Maybe someone know some better way?

I just need graph to always display reference line, even if my data are substantially below it.

Thank you for help.

Re: Reference line to be always displayed - Static Min Doesnt Work.

Anonymous — Fri, 03 Nov 2017 13:36:49 GMT

Sorry if it seems too complex.

My recommendation does address your issue and increases if max bar is much higher.

I'm not sure there is another comparable way.

Because you don't just need to see the reference line you also need the axis to increase if it's much higher than the reference line. You actually have 2 requirements.

If it was really just that you needed to see the reference line, you could set axis to 45 max and you'd be done.

It might help if you provided your actual expression.

Re: Reference line to be always displayed - Static Min Doesnt Work.

vishsaggi — Fri, 03 Nov 2017 14:23:30 GMT

Did my below solution did not work? May be i am missing something.

Re: Reference line to be always displayed - Static Min Doesnt Work.

Anonymous — Fri, 03 Nov 2017 15:28:23 GMT

Vish

Yours would technically work. But it would end up causing the axis to be much higher than the tallest bar. For instance if you have 3 dimensions and Dim1 =10, Dim2=20, Dim3=30; your formula would make the axis max 60 even though the highest bar is only 30.

Re: Reference line to be always displayed - Static Min Doesnt Work.

retko1985 — Fri, 03 Nov 2017 15:32:32 GMT

Doesnt work when value of reference line is above the biggest bar for the made selection, like this:

Re: Reference line to be always displayed - Static Min Doesnt Work.

vishsaggi — Fri, 03 Nov 2017 15:36:31 GMT

Oh you do not want the scale to go either. Got it.