topic Aggregation problem in QlikView

Aggregation problem

Luke_Killer_IT — Wed, 03 Aug 2022 11:08:03 GMT

Hello

Is it possible to add a middle data selection or do you have any idea how I can do it ?

Because the problem is that the command Max(table with date ) does not aggregate my results

Re: Aggregation problem

Or — Tue, 02 Aug 2022 13:20:44 GMT

I'm not really clear on what you're trying to achieve here and what source data you're trying to work with, but generally speaking, if you want subtotals (or sub-max) you should be using a pivot table rather than a straight table, with the relevant Totals enabled (at the dimension level).

Re: Aggregation problem

Luke_Killer_IT — Wed, 03 Aug 2022 12:20:29 GMT

@Or so in the screenshot in the first column is displayed the highest date (max(date)) in the next column is written the date
and I'm interested in the result 07.07.2022 which is calculated like this SubField(MaxString({<SA_Wert.SpaltenID={7}>}SA_Wert.DecWert),';',1).the problem is when I delete the 2nd column it shows me nothing

Re: Aggregation problem

Or — Wed, 03 Aug 2022 12:34:56 GMT

I'm sorry, but I can't seem to understand what it is you're trying to achieve and what you actually have.

If you're looking for the value associated with the maximum date, consider using FirstSortedValue().

Re: Aggregation problem

Luke_Killer_IT — Thu, 04 Aug 2022 12:13:35 GMT

@Or I already explain in more detail . The maximum date must coincide with a given value, but this is not the case. The value was a string, but in the script I converted it to a numeric. as you can see in the screenshot, the corresponding result matching the maximum date is not selected.

Re: Aggregation problem

marcus_sommer — Thu, 04 Aug 2022 13:32:24 GMT

It looked that you have not the right dimensionality - either within the chart or in the data-model. Therefore try it again and at first simplified with the date as dimension and as expression:

if(date = max(date), sum(value))

- Marcus

Re: Aggregation problem

MarcoWedel — Thu, 04 Aug 2022 21:18:45 GMT

please post a small sample application that demonstrates the problem.