topic Set Analysis Query. in QlikView

Set Analysis Query.

Tue, 10 Mar 2015 05:48:07 GMT

PrashantSangle — Tue, 10 Mar 2015 06:04:04 GMT

Hi,

What is your expected output w.r.t provided data??

Regards,

jonathandienst — Tue, 10 Mar 2015 06:05:13 GMT

Use a chart with the relevant dimension (Customer Name or Serial Number) and the expression;

Sum(Aggr(Max(Amount), [Customer Name]))

Sum(Aggr(Max(Amount), [Serial Number]))

HTH

Jonathan

vishsaggi — Tue, 10 Mar 2015 06:07:56 GMT

Hi Murali,

To what I understood please let me know if below would suffice your query.

To get the max purchased amount use the Max function in the expression with Customer Name or Serial Number as dimension using Straight table chart.

Dimension: Customer Name

Expression: max(Amount)

Please let me know if this is what you requirement is: [Image attached]. It displays the max total amount as you have highlighted in your Excel.

robert_mika — Tue, 10 Mar 2015 06:08:25 GMT

This will work as well:

In Textbox:

= Sum(Aggr(Max(Amount), [Sales Order]))

vishsaggi — Tue, 10 Mar 2015 06:21:11 GMT

As the experts mentioned above you can use

sum(aggr(max(Amount), [Customer Name]))

Check the image attached. To get this

1. Go to Char Properties --> Expression Tab --> Total Mode --> Select the Radio button <Expression Total>

2. Go to Presention Tab --> Total option --> Check radio button <Totals on Last Row>

Thanks,
Vish.