topic Re: Avoiding aggregation in qlikview chart in QlikView

Avoiding aggregation in qlikview chart

deepakqlikview_123 — Tue, 31 Jan 2017 12:01:30 GMT

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

Re: Avoiding aggregation in qlikview chart

sunny_talwar — Tue, 31 Jan 2017 12:06:23 GMT

Not sure I understand what you have done.... What is your Aggr() expression look like?

Re: Avoiding aggregation in qlikview chart

sdmech81 — Tue, 31 Jan 2017 12:22:54 GMT

Rather keep one expression say: =sum(1) and hide that.

and add only dimensions that are needed..

Sachin

Re: Avoiding aggregation in qlikview chart

deepakqlikview_123 — Tue, 31 Jan 2017 12:54:10 GMT

I am using sum(Expression)/Currecy conversion in expression but due to this i am able to get all sum

Rather than this i need to show all it is rather than performing sum()

Suppose I have 2 columns

A B

a 1

a 2

Then I have to show whole data as it is rather than showing this ijn straight table

A B

a 3

I Thanks

Re: Avoiding aggregation in qlikview chart

vinieme12 — Tue, 31 Jan 2017 12:55:58 GMT

Qlikview expression aggr function is mandatory

NO it's not, please post sample app

Re: Avoiding aggregation in qlikview chart

deepakqlikview_123 — Tue, 31 Jan 2017 13:03:42 GMT

Then how should i perform

if(Dimensionality() <> 0, (sum(CreditLimit_USD)/FX_CONV_RT)/ScaleValue)

Without aggr

Re: Avoiding aggregation in qlikview chart

vinieme12 — Tue, 31 Jan 2017 13:30:14 GMT

please post a sample app, this exp does not need aggr until you want SUM(AGGR(SUM(....

or you are doing this on a disconnected dimension

Re: Avoiding aggregation in qlikview chart

deepakqlikview_123 — Tue, 31 Jan 2017 17:11:20 GMT

Hi All,

Please find attached sample app.

I need to avoid the aggregation in expresion but rowno() gives performance issues for larger data sets.

Can you please suggest how should i avoid aggregation.

Thanks !

Re: Avoiding aggregation in qlikview chart

sunny_talwar — Tue, 31 Jan 2017 17:33:14 GMT

You don't want to use KeyRow in your chart, but still want to see each and every single row? Is that what you are wanting to do??

Re: Avoiding aggregation in qlikview chart

deepakqlikview_123 — Tue, 31 Jan 2017 17:36:00 GMT

Yeah sunny,

Actually I am using same Keyrow in my chart but it is giving me out of memory issue and not able to display data.

Thanks

Re: Avoiding aggregation in qlikview chart

deepakqlikview_123 — Wed, 01 Feb 2017 05:32:48 GMT

Hi all,

Can you please suggest on this.

Thanks

Re: Avoiding aggregation in qlikview chart

Anil_Babu_Samineni — Wed, 01 Feb 2017 05:35:16 GMT

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

Re: Avoiding aggregation in qlikview chart

deepakqlikview_123 — Wed, 01 Feb 2017 05:45:08 GMT

Already provided attachment in my previous communication

Re: Avoiding aggregation in qlikview chart

deepakqlikview_123 — Wed, 01 Feb 2017 05:47:28 GMT

PFA

Re: Avoiding aggregation in qlikview chart

Anil_Babu_Samineni — Wed, 01 Feb 2017 05:58:46 GMT

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

Re: Avoiding aggregation in qlikview chart

jayanttibhe — Wed, 08 Feb 2017 00:27:22 GMT

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