Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
fabio
Contributor III
Contributor III

Create a "not linear" Date dimension

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

 

2 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
fabio
Contributor III
Contributor III
Author

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