topic Re: Problem in Aggr in QlikView

Problem in Aggr

raghvendrasingh — Tue, 15 Sep 2015 10:11:25 GMT

Hi All,

I am making the new column with the help of previous one,But problem is that When i aggregating with new dimension then it giving the zero.Please look into the qvw application (attached below),The column name is final;it should give the value 900 on the basis of Level0.

Requirement is only use column "Value per level1" not "Value".

Please help us .

Thanks,

Raghvendra

Re: Problem in Aggr

Gysbert_Wassenaar — Tue, 15 Sep 2015 10:21:03 GMT

Are you looking for sum(total <Level0> Value) ?

Re: Problem in Aggr

robert_mika — Tue, 15 Sep 2015 10:23:30 GMT

Try:

if(Dimensionality()=2

, sum(aggr(NODISTINCT sum(Value),Level0,Level1)))

Re: Problem in Aggr

tresB — Tue, 15 Sep 2015 10:23:53 GMT

Use expression: =Sum(TOTAL<Level0>Value)

Re: Problem in Aggr

raghvendrasingh — Tue, 15 Sep 2015 10:27:51 GMT

Hi Gysbert,

Thanks for reply,But I am not looking for this.

I want the same answer with using "Value per level1" Column(i.e. formula column) not Value column.

Because there is a need to implement this scenario in live application.

Thanks,

Raghvendra

Re: Problem in Aggr

raghvendrasingh — Tue, 15 Sep 2015 10:30:38 GMT

Hi,

I want the answer using "Value per level1" Column(i.e. formula column) not Value column.

Because there is a need to implement this scenario in live application.

Thanks,

Raghvendra

Re: Problem in Aggr

tresB — Tue, 15 Sep 2015 10:39:42 GMT

Where is your "Value per level1" column in the sample app?

Re: Problem in Aggr

raghvendrasingh — Tue, 15 Sep 2015 10:51:26 GMT

Hi,

Please find the QVW as attachment again.

Thanks,

Raghvendra

Re: Problem in Aggr

tresB — Tue, 15 Sep 2015 11:01:12 GMT

Your calculated column Value per level1 could be got using: =Sum(Total<Level0,Level1>Value), which is more effective in terms of performance. Now I don't understand why you need this calculated column to use the way you are trying. To say, you can't use a calculated column with Aggr() or Total. May be we could find an alternative have you had explained your real scenario.

Re: Problem in Aggr

raghvendrasingh — Wed, 16 Sep 2015 08:14:40 GMT

Hi Tresesco,

Thanks for suggestion.Now I have moved all formulas to backend.

Now Its Working Fine.

Thanks,

Raghvendra