topic Expression with diffrent date fields in QlikView

Expression with diffrent date fields

Wed, 25 Nov 2020 16:16:04 GMT

I have two tables with datafields.

Table A:

contractid

periodend

date(monthstart(periodend),'YYYY-MM') as PeriodEnd

serviceid

Table B:

serviceid

readingdate

date(monthstart(readingdate),'YYYY-MM') as ReadingMonthYear

annualconsumption

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?

kaushiknsolanki — Wed, 31 May 2017 18:57:10 GMT

Hi Henrik,

You can handle this using the set analysis, but it might be a little complex.

Can you share some sample data to test out.

Regards,

Kaushik Solanki

Thu, 01 Jun 2017 06:03:06 GMT

Hi!

Will this help?

Regards

Henrik

Anil_Babu_Samineni — Thu, 01 Jun 2017 06:43:10 GMT

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?

Thu, 01 Jun 2017 07:20:59 GMT

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-01".

If I change "ReadingMonthYear" to "PeriodEnd" it gives me the consumption for "2016-12-01".