Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate Axis

Hi All,

How do I show  values in x or y-axis (like 1, 3, 5 etc.,) for Order ID. When I use Static Step as 2 it is showing up as (2, 4, 6 instead of 1, 3, 5). I want to see all the 5 rows populated but only scale for the axis as 1, 3 and 5

Below is my sample data.


Thanks

VJ

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like this using a calculated dimension:

2017-05-19 23_51_26-QlikView x64 - [C__Users_Stefan_Downloads_Qlitest.qvw_].png

=If(Odd([Order ID]), [Order ID], Dual(' ',[Order ID]))

View solution in original post

1 Reply
swuehl
MVP
MVP

Maybe like this using a calculated dimension:

2017-05-19 23_51_26-QlikView x64 - [C__Users_Stefan_Downloads_Qlitest.qvw_].png

=If(Odd([Order ID]), [Order ID], Dual(' ',[Order ID]))

View solution in original post