topic Re: expression in QlikView

expression

Thu, 11 Aug 2016 20:09:23 GMT

I have data as mention below.

requirement is like i have to calculate sum of Values.

when user select Type Y from list box and respective values from Sub Type list box it should show maximum value of values as sum.

Like if user select Y from Type list box then select A,C,D from another Sub Type list box sum of values should display 3000 that is maximum value.

in another case if user select N from Type list box and A,B,P from Sub Type list box sum of values should be 2100 that is sum of A,B,P.

Please let me know how to get this sum expression to show above requirement.

sunny_talwar — Thu, 11 Aug 2016 20:14:45 GMT

May be this:

Sum({<Type, [Sub Type] = P([Sub Type])>} Values)

UPDATE: I am not sure how you are coming up with those values? Can you elaborate a little?

Fri, 12 Aug 2016 04:06:31 GMT

I have a similar table as i mentioned and i need to generate the out put like i explain in the question.

Anonymous — Fri, 12 Aug 2016 07:45:08 GMT

Hi Shantnu, try this expression, this is performed for a table chart.

=Pick(Match(Type,'Y','N'),

Sum(Aggr(Max(Values),[Sub Type],Type)) ,

Sum(Aggr(Min(Values),[Sub Type],Type)))

Regards!!

sunny_talwar — Fri, 12 Aug 2016 09:37:11 GMT

I guess I don't understand the logic you are trying to use . May be Manuel solution is what you need here

kaushiknsolanki — Sat, 13 Aug 2016 06:25:39 GMT

Hi,

It seems that you want Max value and also the Sum of value. Both cant be achieved in single expression.

You need to use two expression, one for Max and one for Sum.

and the expression will be simple.

For Max it will be Max(Values) and for Sum it will be Sum(Values)

Regards,

Kaushik Solanki