Values on Dimensions

Tue, 28 Jul 2009 13:18:04 GMT

Hi,

I am creating an Aged Debtors and Creditors tab showing two tables of outstanding AR and AP amounts that fall within various periods (0-30, 30-60, 60-90 etc...)

The ranges of the periods are loaded within a seperate table with three columns [Aged Period], [Aged From] & [Aged To], in which [Aged From] & [Aged To] are inputfields that can be amended by the user.

I have set up [Aged Period] as the dimension for the two Aging tables, but would like to show the corresponding values of "0-30 days", "30-60 days", "60-90 days" etc. instead of "Period 1", "Period 2", "Period 3" as the dimension labels for these Aging tables.

Can anyone advise how I could do this.

Thanks,

Jonathan

Values on Dimensions

amars — Tue, 28 Jul 2009 20:16:10 GMT

Hi Jonathan,

Crate a INLINE Table

Load * INLINE

[ NewLabel, OldLabel

0-30 days, Period 1

30-60 days, Period 2

60-90 days, Period 3

........];

like this & then use the NewLabel instead of the OldLabel. Make sure all values are listed in the table

Regard's

Amar

topic Values on Dimensions in QlikView

Values on Dimensions

Values on Dimensions