topic Re: Help in QlikView

Help

panipat1990 — Fri, 19 Feb 2016 17:33:15 GMT

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

Re: Help

sunny_talwar — Fri, 19 Feb 2016 17:35:14 GMT

Maximum and Minimum would be just one number? Not sure I understand what the end goal/requirement is. Can you elaborate?

Re: Help

panipat1990 — Fri, 19 Feb 2016 17:39:33 GMT

If i select one id then it show maximum and minimum revenue corresponding selected id.........supoose i select one then it show 10 or 40 values in revenue field..

Re: Help

sunny_talwar — Fri, 19 Feb 2016 17:42:10 GMT

Where did 40 come from? ProcessID 1 has only one row of data and for that row the Revenue = 10. So Min = Max = 10.

Re: Help

panipat1990 — Fri, 19 Feb 2016 17:48:16 GMT

Suppose i select any proccessid from 1 to 12....then it show in revenue field minimum and maximum value...and which group show.....Means one id corresponding 2 value show minimum and maximum

Re: Help

panipat1990 — Fri, 19 Feb 2016 17:52:39 GMT

if i select process id 1 to 4 then it show maximum and minimum revenue like 10 or 40

if i select process id 5 to 8 then it show max and min value like 50 or 80 in revenue

if i select process id 9 to 12 then it show max and min value like 90 or 120 in revenue

Re: Help

kaushiknsolanki — Fri, 19 Feb 2016 17:58:38 GMT

Hi,

Try this expressions.

Max({<Group = {"$(=maxstring(Group))"},ProcessID=>} Revenue)

Min({<Group = {"$(=maxstring(Group))"},ProcessID=>} Revenue)

Regards,

Kaushik Solanki

Re: Help

petter — Fri, 19 Feb 2016 18:04:16 GMT

Please respect the "guidelines for posting" for this forum and put a descriptive title for you question.

Writing "Help" as a description/title is hardly informative

kind regards

Petter

Re: Help

panipat1990 — Fri, 19 Feb 2016 18:04:27 GMT

If I select any id from 1 to 4 like 1,2,3,4 then it show maximum and minimum revenue like 10 or 40....

Same 5 to 8 or 9 to 12.................and show with groups......please help me sir....

Re: Help

sunny_talwar — Fri, 19 Feb 2016 18:05:31 GMT

And you want to see this information in text box object?

Re: Help

panipat1990 — Fri, 19 Feb 2016 18:09:27 GMT

Yes sir

Re: Help

sunny_talwar — Fri, 19 Feb 2016 18:11:29 GMT

May be this:

Expressions used

1) =FirstSortedValue(DISTINCT Group, -Revenue)

2) =Max(Revenue)

3) =FirstSortedValue(DISTINCT Group, Revenue)

4) =Min(Revenue)

Re: Help

sunny_talwar — Fri, 19 Feb 2016 18:18:49 GMT

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)

Re: Help

panipat1990 — Fri, 19 Feb 2016 18:27:58 GMT

Thanks sir it is helpful for me

Re: Help

panipat1990 — Fri, 19 Feb 2016 18:28:30 GMT

Thanks Sir

Re: Help

sunny_talwar — Fri, 19 Feb 2016 18:30:27 GMT

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

Re: Help

MarcoWedel — Fri, 19 Feb 2016 21:03:40 GMT

Hi Sunny,

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

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