topic Re: Create a "not linear" Date dimension in QlikView

Create a "not linear" Date dimension

fabio — Thu, 13 May 2021 08:51:18 GMT

Hi,

i would like create a chart (table) like that:

[Date], [weigth]

backward 100Kg

may 120Kg

jun 14Kg

jul 25Kg

Aug 123Kg

further 12Kg

It's just a simple example for help me tu explain you.

A need to show the values in a range splitted by a dimension (month, day..) and "sum" all the value existing outside this range in a "virtual" value of the dimenson (backward e further..)

Any idea?

thanks

Re: Create a "not linear" Date dimension

Gysbert_Wassenaar — Thu, 13 May 2021 09:55:35 GMT

Create a new field with your custom date value 'further':

CustomMothnDimension:
LOAD * INLINE [
CustomMonth, YourExistingMonthFieldHere
may, may
jun, jun
jul, jul
aug, aug
further, sep
further, oct
further.... etc
];

Then use the new CustomMonth field as dimension in your chart.

Re: Create a "not linear" Date dimension

fabio — Thu, 13 May 2021 13:09:57 GMT

Thanks, but it needs to work dinamically, based on the current month selection 😞