topic Re: Convert dimension to show lifetime trend in QlikView

Convert dimension to show lifetime trend

Anonymous — Thu, 24 Mar 2016 12:10:47 GMT

I have a simple line chart with Date as dimension and two expressions. The first expression runs for a longer period than the second (as in the attached example). What I would like to do is show them both starting at the same point under a universal date dimension (for example, month 1, month 2 etc).

I have attached a QVW which highlights this. The first chart displays the current view and the second chart the desired result. I have manipulated the data to get the desired result but would ideally like to get to it by either changing the original chart properties or maybe even the script. Although, a script change may affect the calendar as a whole and other data tables.

I'm not sure if this is possible but am open to any suggestions!

Many thanks in advance.

Mehul

Re: Convert dimension to show lifetime trend

sunny_talwar — Thu, 24 Mar 2016 12:58:03 GMT

Not sure, but something like this?

Re: Convert dimension to show lifetime trend

swuehl — Thu, 24 Mar 2016 13:16:01 GMT

Or maybe using a calculated dimension that may react on user selections in your calendar fields.

=Aggr( Rangesum(Only({<Value={">0"}>} 1),0,Rowno()), Type, CalendarMonthName)

[using a script Crosstable transformation to create Type / Value fields from your input table]

Re: Convert dimension to show lifetime trend

Anonymous — Thu, 24 Mar 2016 13:40:34 GMT

HI both,

Thank you for the quick responses.

Sunny, although this solution does work, I'm looking to have an arbitrary value for the month in order to track lifetime activity.

swuehl, this works perfectly, thanks! I'm not concerned about selections but nice to know there is some flexibility.

Mehul