topic Re: Dimension Limits : Last * days available? in QlikView

Dimension Limits : Last * days available?

Wed, 25 Nov 2020 16:16:04 GMT

Hi!!

I want to show the more recent 10 days of data. so It seems like I will need LAST ** Values but they only have first ** values.

does anyone have solution for this?

Thank you!!

Re: Dimension Limits : Last * days available?

swuehl — Thu, 09 Feb 2017 22:08:21 GMT

Maybe just change the sort order?

You can also limit the dimension values using a calculated dimension or set analysis.

Re: Dimension Limits : Last * days available?

Thu, 09 Feb 2017 23:42:40 GMT

then another problem arises which is the most recent values will be on the left not on the right.

Re: Dimension Limits : Last * days available?

jayanttibhe — Thu, 09 Feb 2017 23:47:36 GMT

Try using Rank() function

Re: Dimension Limits : Last * days available?

Anil_Babu_Samineni — Fri, 10 Feb 2017 01:57:27 GMT

I want to show the more recent 10 days of data. so It seems like I will need LAST ** Values but they only have first ** values.

Then Move into Last instead of First from your Dimension Limits. And the As SW suggest, You can use Sort. But, I doubt how you are doing.

Can you send expression to do this and where you are doing this(I mean Which Object)

Re: Dimension Limits : Last * days available?

vinieme12 — Fri, 10 Feb 2017 06:07:22 GMT

then another problem arises which is the most recent values will be on the left not on the right.??

what exactly do you mean by this? can you show a screengrab of what you mean?

Re: Dimension Limits : Last * days available?

swuehl — Fri, 10 Feb 2017 08:46:19 GMT

You can limit the dimension values also using calculated dimensions or set analysis in all your aggregations.

For example, using a calculated dimension in dimension tab:

=Aggr( If(Rank(DATEFIELD)<=10, DATEFIELD), DATEFIELD)

DATEFIELD needs to have a numerical representation, like all date fields created with QV date functions.

Enable 'Suppress when value is NULL' option on dimension tab and disable the dimension limits (if they are still enabled).

Re: Dimension Limits : Last * days available?

Fri, 10 Feb 2017 10:27:44 GMT

U can sort the data and take first 10

Re: Dimension Limits : Last * days available?

andy — Fri, 17 Mar 2017 08:49:49 GMT

I think the answer was given in this thread

https://community.qlik.com/thread/47506

by beanmachine

Switch off any dimension limits
In the Presentation tab, tick 'Enable X-Axis Scrollbar'
Set 'When Number of Items Exceeds' to a the level that suits you
Tick 'Reversed'

This will show you the last X (for instance, months) in the correct order. You can scroll back to the left to show lower values but the default will be to show the last X values from the maximum.

This seems to do the trick although it would be easier if the Dimension Limits included a 'Last' setting to replicate what we had before the upgrade.