Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Sum(Descendants) in MDX Part II

Dear

sum({<#Equipment = {">0"}>}SalesAmount) / sum(#Equipement)

Sum(if(#Equipment >0, SalesAmount,0)) / Sum(#Equipment)

Both of them, give me the same result but it is not what I want. This is becasue there is two records of customer 1004.

In SQL Analysis Services, I can get the answer by using this MDX.

sum(Descendants([Customer].CurrentMember,[Customer].Customer),

(iif ([Measures].[#Equipment)] > 0, [Measures].[SalesAmount] / , 0))) / [Measures].[#Equipment]

Please advise.

Best Regards,

Anote

1 Solution

Accepted Solutions

Sum(Descendants) in MDX Part II

Hi,

   Please refer to the post.

   http://community.qlik.com/message/127972#127972

Regards,

Kaushik Solanki

1 Reply

Sum(Descendants) in MDX Part II

Hi,

   Please refer to the post.

   http://community.qlik.com/message/127972#127972

Regards,

Kaushik Solanki

Community Browser