Avoiding aggregation in qlikview chart

[deepakqlikview_123]

Hi,

How should I prohibit aggregation in qlikview chart level as in Qlikview expression aggr function is mandatory but when I am using Rowno for creating separate columnin backend and using same col in chart and hiding that it is giving me eoor like out of memory object.

Can you please suggest how should i tackle on this issue.

Thanks

[deepakqlikview_123]

Hi all,

Can you please suggest on this.

Thanks

[Anil_Babu_Samineni]

Better to solve, Provide sample data and expected output. They we were look into that without Aggregation as you want

[deepakqlikview_123]

Already provided attachment in my previous communication

[deepakqlikview_123]

PFA

[Anil_Babu_Samineni]

I forget to follow earlier conversation. Anyhow, good notice. I don't think so whether it is possible with out Aggregation. Will get back you if i found any other solution

[jayanttibhe · Accepted solution]

Hi Deepak,

You trying to aggregate at "Granular level" than the KEY field used which is not possible in any case.

Ultimately you want the FACT calculations on the actual ROWs which are presentin the FACT table. In this case, even though you are using the Straight Table, in the expression tab DONT use any aggregation function. i.e.

instead of -

(sum(OpenAR_USD)/FX_CONV_RT)/ScaleValue

You can simply use : - Dont use any Aggregation Function.

((OpenAR_USD)/FX_CONV_RT)/ScaleValue

Now, this will work in all the cases except when you have all the Dimensions in the Straight Table with SAME set of Values. In that case you ll get NULLs as Qlik cannot differentiate which measure  (Expression value ) you want to Pick on the single set of dimensions. In this case you need a lower (Lowest in the case - As you wanted ALL the Rows from Fact Table) ; So Rowno() makes sense to me and then hiding this column from your straight table.

I would rather suggest use Recno() as you want the counter on your INPUT data and not the output data.

Basically, if want to show data on LOWER level than the actual Chart dimensions, then you need to pull that dimension in the Chart whether that's hidden dim or visible Dim - it should be present in the chart.

Also, I think dimensionality() function is not needed as it makes sense for Pivot Tables only.

Thanks

Jayant