Discussion Board for collaboration related to QlikView App Development.
I have two tables with datafields.
date(monthstart(periodend),'YYYY-MM') as PeriodEnd
date(monthstart(readingdate),'YYYY-MM') as ReadingMonthYear
Im using a listbox with the field "PeriodEnd" to choose the months where contracts end, and then a straight chart
with the dimension "PeriodEnd" and then expressions to show diffrent contracts.
What Im trying to figure out is how to show the correct annualconsumption for the PeriodEnd,
For ex, if PeriodEnd is "2016-12" the correct reading date for the consumption is "2017-01".
If I change "ReadingMonthYear" to "PeriodEnd" it gives me the consumption for "2016-12", how can I solve this with an expression?
You can handle this using the set analysis, but it might be a little complex.
Can you share some sample data to test out.
Will this help?
I may miss few points to read, can you explain little more. When i opened the Application it is showing 2016-12-01. What are you expecting?
For ex, if PeriodEnd is "2016-12" the correct reading date for the consumption is "2017-01-01".
If I change "ReadingMonthYear" to "PeriodEnd" it gives me the consumption for "2016-12-01".