Help

[panipat1990]

Hi Team,

          I have a requirement.please help me...I am sharing a qvw...Requirement is

If i Select any processid....then it show in maximum and minimum revenue......and which group...please help me

[panipat1990]

Yes sir

[sunny_talwar]

May be this:

Expressions used

1) =FirstSortedValue(DISTINCT Group, -Revenue)

2) =Max(Revenue)

3) =FirstSortedValue(DISTINCT Group, Revenue)

4) =Min(Revenue)

[sunny_talwar · Accepted solution]

I think I understand what you want. If you select a ProcessID, you want to see the max based on the group it belongs to:

Try these:

=Max({<ProcessID, Group = p(Group)>}Revenue)

=Min({<ProcessID, Group = p(Group)>}Revenue)

[panipat1990]

Thanks sir it is helpful for me

[panipat1990]

Thanks Sir

[sunny_talwar]

If you got what you were looking for, please close the thread by marking correct and helpful answers Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[MarcoWedel]

Hi Sunny,

Panipat1990 usually does not respond to polite requests to follow community procedures:

Re: Help

Re: Help

Re: Help

Re: Help

Re: Help

Re: Help

Re: Help

Re: Help

Re: Help

He still has lots of  open threads but no closed ones (although stating he closed some:Re: Logic‌)

Personally I found an answer to the question whether I want to continue investing time in answering his questions.

have a nice day

Marco