Wiered Calculation

[smilingjohn]

Hi All, 

I am using a table in Qliksense .Here i see something wrong in this . 

I am using 3 columns as dimension  ID , AreaSale and Profit and in a measure i am using the expression like 

(Sum(AreaSale)+sum(Profit ) ) . but here at the last of every ID it is showing overall sum Can  as shown in the  screenshot below. Please help me in correcting this

 Thanks in Advance

[Anil_Babu_Samineni]

Try like this for measure for debug and provide screenshot?

1) Sum(AreaSale)

2) Sum(Profit)

3) Colum(1)+Column(2)

4) Column(3)/2

[smilingjohn]

@ Anil Babu  

I did the exact as per your suggestion . 

Now i am getting sum of all the ID's as shown in the figure below   ( This is the reason i was consider it as dimesnion ) 

[Anil_Babu_Samineni]

There are some aggregation rows are calc differently, Now looks good - Can you try the same in another chart with your expression. 

[smilingjohn]

@Anil_Babu_Samineni 

I tried with different chart but the result is again the same as shown in the figure below . Why is this happening ? 

I have done everything sir need your help on this 

[Anil_Babu_Samineni]

Since it is coming as %, can you confirm what is the format you used? try first without format in percentage and see?

[smilingjohn]

I have added % symbol at the end of the expression like below 

(Sum(AreaSale ) + Sum(Profit) )/2&'%'

[Anil_Babu_Samineni]

Try this

Num((Sum(AreaSale ) + Sum(Profit) )/2, '#,#0%')

[smilingjohn]

it is the same behaviour only the format changes of decimal 

[Anil_Babu_Samineni]

Sorry, It's difficult to answer until unless sharing sample allpcation which demonstrate the issue about data?