Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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

an anyone please help. :/

MVP
MVP

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

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

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

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.

Community Browser