Incorrect values when associated with the dimension

[#1]

Hi,

I have created a table with outline as shown below:

Table1

Load
  UniqueID,
'Year Forecast' as Dimension
  Resident main;

  Left Join(Table1)

Temp:

Load
UniqueID,
Manager1,

Manager2,

Manager3

Resident Table2;

Temp table is pulling the mentioned fields from another table called Table2 using Resident Load.

In the front end, I am building a Straight Chart with

'Dimension' as my Dimension

&

Expression, which is a sum of three different fields ( sum(field1) + sum(field2) + sum(field3)).

But I don't see the expression validating properly. I only get the value of sum(field1) in the chart.

Surprisingly, when I used the same expression in a Text Box, I see the right value.

What might be the issue here? It's literally the same fields and same expression. Then why do I see the correct value in the textbox but not in the chart?

Could it be the dimension?

I really appreciate it if someone answers it ASAP as I am stuck at this issue for a long time now and my next operation depends on building this.

[trdandamudi]

Is it possible to post a sample app ?

[#3]

I wish I could. But the data I am pulling is huge and interconnected. The fields which I am using in SUM are generated using multiple operations and joins within the script.

[trdandamudi · Accepted solution]

May be try this:

Dimension' as my Dimension

Expression: ( sum(Total field1) + sum(Total field2) + sum(Total field3) ).

[sunny_talwar]

Where is field1, field2 coming from? I don't see it in the Table2 load above? Please provide information which matches the script you are providing.

QlikCommunity Tip: How to get answers to your post?

[johngouws]

The text box is not aggregated to a Dimension whereas the Chart is.

Without more information I would say there is a "Key" issue. You will probably need work on the UniqueID key.

Something like "trim(upper(UniqueID))&trim(upper(?????)) as UniqueID"

[#7]

field1 and field2 are coming from two different tables Sunny. Every table is connected via the UniqueID field.

[#8]

Thank you so much Thirumala Dandamudi

Your expression solved my issue. I would really appreciate it if you could tell me what's the difference between

old exp:  ( sum(field1) + sum(field2) + sum(field3)).

new exp: ( sum(Total field1) + sum(Total field2) + sum(Total field3) ).

Also, thanks to Sunny for your help

[trdandamudi]

old exp:  ( sum(field1) + sum(field2) + sum(field3)).  <--- It will consider the dimension ( It will Sum based on Dimension breakup)

new exp: ( sum(Total field1) + sum(Total field2) + sum(Total field3) ) <--- It will ignore the dimension while summing up.

Hope this is clear..

[#10]

Yes, but when I select the dimension, the values are again changing.

I mean, the values look good in the overall view, but whenever I select my 'Year Forecast' dimension, only that row is shown, which is fine but the values are changing.