Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change the show of Dimension

Hi,

Now I have a table like this

111.jpg

how can I change the show of X-value dimension like the following?

222.jpg

13 Replies
MK_QSL
MVP
MVP

You need to limit your dimensions by If Condition...

Kindly let us know what is the dimension you used and how you get your dimension

i.e. if MonthYear is the dimension, what is your formula in script...

we can use Dual function or Autonumber to create an ID for it and can use in calculated dimension.

Not applicable
Author

Yes the dimension is Yearmonth and it's the original field name...

How can I use the function you mentioned? Do it affect the calculated expression?

What I want  is not show all of the label of the yearmonth but every 6 month.

Not applicable
Author

What should I do next step?

MK_QSL
MVP
MVP

Can I have your sample data file or sample apps?

Not applicable
Author

Hi Sorry for late.

The attachment is the sample data. Please help to see.

Anonymous
Not applicable
Author

See the attached

Not applicable
Author

Thanks.

But in your attachment the X-Axes just show the smallest 10 value like this:

200803  200804  200805   200806    200807   200808   200809    200810   200811    200812

I think I need the show of the X-Axes every 6 month......

200803    200809    200903   200909    201003   201009   201103   201109    201203    201209   

What Should I do?

Anonymous
Not applicable
Author

Here it is

Not applicable
Author

but in this way, it will only show expression result for the limited dimension