Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

prma7799
Honored Contributor III

How to break the data points

Hi All,

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

0.5

5

7.5

10

12.5

15

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

Please see the attached

1 Solution

Accepted Solutions
MVP
MVP

Re: How to break the data points

Hi,

In Axes tab set like this

Static Min : 0

Static Step : 2.5

for both the expresions.

Regards,

Jagan.

8 Replies

Re: How to break the data points

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

prma7799
Honored Contributor III

Re: How to break the data points

Hi Sunny,

I want to break the scale on both side like

0.5

5

7.5

10

12.5

15

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 )

MVP
MVP

Re: How to break the data points

Hi,

In Axes tab set like this

Static Min : 0

Static Step : 2.5

for both the expresions.

Regards,

Jagan.

prma7799
Honored Contributor III

Re: How to break the data points

Hi Jagan,

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

PFA...

hirishv7
Honored Contributor

Re: How to break the data points

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

Or

else Change number format settings.

Thanks.

MVP
MVP

Re: How to break the data points

Hi,

Then In Axes tab set like this

Static Min : 5

Static Step : 5

for both the expresions.

Regards,

Jagan.

prma7799
Honored Contributor III

Re: How to break the data points

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

MVP
MVP

Re: How to break the data points

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.

Community Browser