topic Re: Ask for Expression in QlikView

Ask for Expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a data like this:

I want to get AVG_RH value in max(DATE) and Min(DATE) for each ITEM_ID and PART_ID.

For example ITEM_ID = P and PART_ID = P1

I want to get AVG RH in MAX DATE (13-Aug-2018) and MIN DATE(12-FEB-2018) so the result must be in Calculation column above.

Can somebody help me.

Thanks

Anonymous — Fri, 05 Oct 2018 03:54:30 GMT

Where do you want to see the result? text object?

PrashantSangle — Fri, 05 Oct 2018 05:22:52 GMT

Is avg rh coming from back end or you are calculating it at front end???

Regards,

Anil_Babu_Samineni — Fri, 05 Oct 2018 05:57:41 GMT

Try this way? Not tested - But this may work.

If(DATE=Max(TOTAL <PART_ID> DATE), Sum(TOTAL <DATE,PART_ID> AVG_RH)) & '-' & FirstSortedValue(TOTAL <PART_ID> AVG_RH, Aggr(Sum(AVG_RH), PART_ID))

If(DATE=Max(TOTAL <PART_ID> DATE), Sum(TOTAL <DATE,PART_ID> AVG_RH), Sum({<DATE={"$(=Max(DATE))"}>} AVG_RH)) & '-' &

FirstSortedValue(TOTAL <PART_ID> AVG_RH, Aggr(Sum(AVG_RH), PART_ID))

FirstSortedValue(TOTAL <PART_ID> AVG_RH, -Aggr(Sum(AVG_RH), PART_ID))-FirstSortedValue(TOTAL <PART_ID> AVG_RH, Aggr(Sum(AVG_RH), PART_ID))

Anonymous — Mon, 08 Oct 2018 03:35:55 GMT

Hi,

Thanks for your solution, it solved my problem perfectly !

Anil_Babu_Samineni — Mon, 08 Oct 2018 13:46:38 GMT

Glad it worked, Which one worked for you?