Max value issue

ravindraa — Fri, 01 Apr 2016 08:56:16 GMT

Hi Friends

I have struck in one place please give me some suggestion to come out from this.

In my data base i have one date it has following fields like Date,Scheme,Plan,amount.

Here my requirement is i have to show the chart scheme and plan wise Amount.

To get amount one condition is there that i have to take Max date value like

--> for example we have scheme AB, under AB scheme we have two plans like (0A,0B) ,here 0A plan has two times , here as per the condition i have to max date plan amount like wise for all the scheme i have to display the chart, but here the problem is i wrote the set analysis like below

sum({<Date={"$(=max(Date))"}>}amount) , but it is giving max date value as per the date filed not for the scheme wise and plan wise.

please give me some suggestion how to get the value.

Thanks in advance.

Please find attached documents.

Re: Max value issue

sunny_talwar — Fri, 01 Apr 2016 08:59:38 GMT

Is this what you are looking for?

Dimensions

1) Scheme

2) plan

Expressions

1) Date(Max(Date))

2) FirstSortedValue(amount, -Date)

Re: Max value issue

ravindraa — Fri, 08 Apr 2016 04:55:43 GMT

Hi Sunny,

Thank you very much for giving suggestion.

Thanks & Regards

Niranjan

topic Max value issue in QlikView

Max value issue

Re: Max value issue

Re: Max value issue