Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

How do you show the last 12 values on the Demension limits tab?

On a line Chart Properties Demension Limits I need to show only the last 12 values out of a list of 36 values. The only options are First, Largest,and Smallest.

Does anyone have any suggestions?

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: How do you show the last 12 values on the Demension limits tab?

Maybe like attached?

Try using a calculated dimension:

=aggr(if(rank(Date) <=12,Date),Date)

View solution in original post

5 Replies
Not applicable

Re: How do you show the last 12 values on the Demension limits tab?

The options are based on the sort order. If you want to have the last 12 values (assuming the sort is based on an expression) reverse the sort order and fix to first 12 values. Just play around with sort order and the limit options.

If you could not figure out, scramble and share your qvw.

Regards,

Kiran Rokkam.

Not applicable

Re: How do you show the last 12 values on the Demension limits tab?

I do not understand why the option to select “Last” wasn’t included in the list. I need to select the last 12 dates with the oldest date to the left. Any help will be appreciated.

Dave Benzenhafer

Re: How do you show the last 12 values on the Demension limits tab?

Hi,

     Please see the attached file.

Hope it helps

Not applicable

Re: How do you show the last 12 values on the Demension limits tab?

I need the latest date to be to the right of the graph.

Dave Benzenhafer

MVP
MVP

Re: How do you show the last 12 values on the Demension limits tab?

Maybe like attached?

Try using a calculated dimension:

=aggr(if(rank(Date) <=12,Date),Date)

View solution in original post