topic Re: How to break the data points in QlikView

How to break the data points

prma7799 — Tue, 03 Nov 2015 03:27:03 GMT

Hi All,

How to break the values in X and Y axis like below

0.5

7.5

12.5

17.5 like this...........

Please see the attached

Re: How to break the data points

sunny_talwar — Tue, 03 Nov 2015 03:29:17 GMT

Not entirely sure I understand the requirement. What exactly are you trying to do?

Re: How to break the data points

prma7799 — Tue, 03 Nov 2015 03:33:52 GMT

Hi Sunny,

I want to break the scale on both side like

0.5

7.5

12.5

17.5

as in the attachment have scale 0 5 10 15 20 and 0 -5 and right hand side 0 5 10 and -5 -10 -15....

(like seconds we have milliseconds )

Re: How to break the data points

jagan — Tue, 03 Nov 2015 03:42:00 GMT

Hi,

In Axes tab set like this

Static Min : 0

Static Step : 2.5

for both the expresions.

Regards,

Jagan.

Re: How to break the data points

prma7799 — Tue, 03 Nov 2015 03:50:07 GMT

Hi Jagan,

Your suggestion is right but i want to remove the zero in 5 10 15 20

PFA...

Re: How to break the data points

HirisH_V7 — Tue, 03 Nov 2015 04:08:36 GMT

You can write in expression like ..if('Field'='0' or '7' ,Null())

else Change number format settings.

Thanks.

Re: How to break the data points

jagan — Tue, 03 Nov 2015 04:11:40 GMT

Hi,

Then In Axes tab set like this

Static Min : 5

Static Step : 5

for both the expresions.

Regards,

Jagan.

Re: How to break the data points

prma7799 — Tue, 03 Nov 2015 04:27:16 GMT

If i set like above then 2.5 7.5 12.5 will not visible.

Re: How to break the data points

jagan — Tue, 03 Nov 2015 05:38:44 GMT

Then set like below

Static Min : 2.5

Static Step : 2.5

Now you will get values like 2.5, 5, 7.5, 10, 12.5 etc.

Regards,

Jagan.