2 expressions in the same curves chart

[absekrafi]

Dear community,

I want to display simultaneously 2 functions:

1. The first is a Sum() of a mesure.

2. The second is the mesure it self (no function applied on it).

I am not getting the curv of the second expression.

Could you please point me to what is wrong?

Kind regards,

[sunny_talwar · Accepted solution]

Do you have a single value of BUDGETA for each year? If not, then this probably need to have some sort of aggregation to handle multiple values. Sum, Avg, Min, Max... etc

[absekrafi]

I mean 2 lines graphs

[sunny_talwar]

Abdallah Sekrafi wrote:

I mean 2 lines graphs

[absekrafi]

Hi Sunny,

I have the same BUDGETA  value for each year but I have 2 dimentions for it which are : Product, Factory and the Year.

It's the same for QUANTPRODTOTALE it has the same dimentions Product, Factory and the Year. (but here I need I to Sum the values.

[sunny_talwar]

not entirely sure I understand... would you be able to share a sample and explain what exactly is the output you are hoping to see?

[absekrafi]

I relized that I have to do a Sum on BUDGETA also but the value are wrong compared to SQL queries.

Using SQL I found for the year 2014:

- Sum(BUDGETA) = 3 842 164

- Sum(QUANTPRODTOTALE) = 6 987 120,5.

But the Qlikview is showing me different values (please below).

[bc-thebruuu]

Can you try to use one of the two following functions:

only(BUDGETA)

Num(concat(distinct BUDGETA))

and may you share a test app?

[sunny_talwar]

I won't know unless you can provide a sample?

[absekrafi]

Hi Sunny,

Hi Bruno,

I fixed the problem. Before I was joining the two tables. I serated each Table and I fixed the synthetic table by using a composite key.

Sum() agr function is working and giving me the correct values.

Thank you very much,

Abdallah