topic Re: MIN GRAPHIC SCALE in QlikView

MIN GRAPHIC SCALE

philgood34 — Sat, 07 Oct 2017 06:46:36 GMT

Hi everybody

I try to improve the appearance of a graph by customizing the scale

I would like the y-axis to start at 90% of the minimum value for example

I tried, but i don't know the syntax with "min" or "range min" applied to the sales values (Measure is Sum({<Flag = {'CY'}>}VMS_CATTC)) for the period (Dimension is AsOfMonthYear)

Regards

Philippe

Re: MIN GRAPHIC SCALE

pradosh_thakur — Sat, 07 Oct 2017 07:13:10 GMT

try this

if dont want it to be changed by selection.

=min({1}aggr(Sum({1<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

else

=min(aggr(Sum({<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

edit:

You may want to check for the flag. If you want to include all the value or only for 'CY'. edit that as per your requirement.

regards

Pradosh

Re: MIN GRAPHIC SCALE

philgood34 — Sat, 07 Oct 2017 07:55:13 GMT

Hi Pradosh

i tried the second expression in a tab to see the result ...

it seems that it does not work ?

have you an idea ?

Thank's in advance

Philippe

Re: MIN GRAPHIC SCALE

pradosh_thakur — Sat, 07 Oct 2017 08:18:09 GMT

1:Try using that in a text box and check the result.

2: Use the expression in MIN(for setting the min value of Y axis for Sales) not in another tab

edit: we missed a '{' . I have edited the same in the previous reply too. so it will work for you now. Let me know if it works and close the thread by marking answers helpful and correct.

try this

min(aggr({Sum(<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

regards

Pradosh

Re: MIN GRAPHIC SCALE

Frank_Hartmann — Sat, 07 Oct 2017 08:20:59 GMT

=min(aggr(Sum({<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

Re: MIN GRAPHIC SCALE

philgood34 — Sat, 07 Oct 2017 08:29:51 GMT

Sorry .. Still does'nt work ??

Re: MIN GRAPHIC SCALE

philgood34 — Sat, 07 Oct 2017 08:34:34 GMT

Yes i just saw it !

min(aggr({Sum(<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

min(aggr({Sum({<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

it works in the tab also

thank's a lot !!!

Regards

Philippe

Re: MIN GRAPHIC SCALE

pradosh_thakur — Sat, 07 Oct 2017 08:39:05 GMT

you are still writing it wrong Philippe

not this -> min(aggr({Sum(<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

this

-> =min(aggr(Sum({<Flag = {'CY'}>}VMS_CATTC),AsOfMonthYear))*0.9

Re: MIN GRAPHIC SCALE

philgood34 — Sat, 07 Oct 2017 09:48:39 GMT

It's ok , i was to show the mistake

Thank's