topic Recording Rate of Change in QlikView

Recording Rate of Change

Mon, 17 Nov 2014 11:27:42 GMT

Hi All,

I have a question I was hoping you may be able to help me with. I am trying to record a percentage change in the number of values between the points on the line chart. I'm still unsure about the particular visualisation method, my I need qlikview to compute a % increase/decrease in a number of observations between each to dates on my chart (I use dates as a dimension). Right now my expression looks like that:

((Sum(FLAG_P11) - sum({<[Trade Date] = {$(=Date([Trade_Date]-1))}>} FLAG_P11)/sum({<[Trade Date] = {$(=Date([Trade_Date]-1))}>} FLAG_P11))*100

The sum(...) expressions sum up my observations for each date, and I think my set analysis expression {$(=Date([Trade_Date]-1))} which was intended to return the previous date is the source of the problem. I am quite new to qlikview and don't really know how to write a correct set analysis command to return flags at the date less than a day.

I hope it makes sense and someone is able to help!

Thank you so much in advance!

Re: Recording Rate of Change

tresB — Mon, 17 Nov 2014 11:59:00 GMT

Set analysis with date field is always a bit tricky, date formats (of field itself and the returned date by expression) have to be similar. If you could share a sample qvw, could be looked into. Check this for sharing qvw: Preparing examples for Upload - Reduction and D... | Qlik Community

Re: Recording Rate of Change

Mon, 17 Nov 2014 12:20:52 GMT

Thank you so much for your offer, but I can't really share the file even in a reduced form - work requirements. Sorry to be ungrateful/uncooperative!

Re: Recording Rate of Change

gshockxcc — Thu, 14 May 2015 14:46:22 GMT

Hi Adam,

I am interested in a similar example. Could you post a sample file with bogus data? It doesn't even have to be relevant to your work example. Rate of change is applied the same way, no matter the propriety of the data.