Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Change the show of Dimension

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

Re: Change the show of Dimension

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

Re: Change the show of Dimension

What should I do next step?

Re: Change the show of Dimension

Can I have your sample data file or sample apps?

Not applicable

Re: Re: Change the show of Dimension

Hi Sorry for late.

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

vamshi_1957
Contributor II

Re: Re: Re: Change the show of Dimension

See the attached

Not applicable

Re: Change the show of Dimension

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?

vamshi_1957
Contributor II

Re: Re: Change the show of Dimension

Here it is

Not applicable

Re: Change the show of Dimension

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

Community Browser