Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Find out min and max Dates and show a value only from this row

Hi,

I'm using these solutions but not able to get the correct answer

  1. Sum(If(Aggr(NODISTINCT Min(Date), ID) = Date, Value)) : This is giving me twice the value.
  2. Sum(Aggr(FirstSortedValue(Value, -Date), ID)) : This not giving me any result

Can anybody please help me what should I do. I've attached the qvf the output should be like in Demo-Sheet 1 I've used both the formula's in demo sheet 2.

3 Replies
Not applicable
Author

an anyone please help. 😕

sunny_talwar

Hi Shivam -

Not sure what the issue is, but on both the tabs (Demo 1 & Demo 2), I am seeing the following error. Are you using some kind of extension?

Capture.PNG

Not applicable
Author

No, I'm not using any extensions. I don't know why that's happening. I'm attaching a new qvf. Please check this. The output should be how it is in Demo Sheet 2. I've used the above-stated formulae in Demo Sheet 1.

When using formula 1 I'm getting double the values.

When using formula 2 I'm not getting any output.