topic Re: Re: Scatter chart scaling issue when using dates in QlikView

Scatter chart scaling issue when using dates

nicktodd — Thu, 09 Jan 2014 12:39:31 GMT

I have a scatter chart that plots user IDs based on two dates. The x-axis is OK but for some reason I can't get the y-axis to scale correctly - it shows a large range which I can't seem to change.

Does anyone have any ideas?

Thanks

Nick

Re: Scatter chart scaling issue when using dates

maxgro — Thu, 09 Jan 2014 17:03:14 GMT

Hi Nick

why not try to use the tab Axes and set (Y axes)

Static min = min(Application)-20

Static max = max(Application)+20

Regards

Re: Scatter chart scaling issue when using dates

nicktodd — Fri, 10 Jan 2014 08:44:30 GMT

Massimo

Thanks for your reply - I tried that but it makes no difference unfortunately

Regards

Nick

Re: Re: Scatter chart scaling issue when using dates

maxgro — Fri, 10 Jan 2014 09:42:57 GMT

Hi Nick

perhaps I don't understand your question but It seems to me that y-axis is different from your original .qvw; using expression in Static min/max you can adjust Y (and X too) axis

See attachment

Regards

Re: Scatter chart scaling issue when using dates

nicktodd — Fri, 10 Jan 2014 10:08:49 GMT

Massimo

Ah - now I see my error - I had put the min/max entries on the x-axis by mistake!

Many thanks for your help - your solution is perfect.

Regards

Nick