Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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!
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.