topic Re: 2 expressions in the same curves chart in QlikView

2 expressions in the same curves chart

absekrafi — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: 2 expressions in the same curves chart

sunny_talwar — Wed, 16 May 2018 11:00:18 GMT

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

Re: 2 expressions in the same curves chart

absekrafi — Wed, 16 May 2018 11:04:46 GMT

I mean 2 lines graphs

Re: 2 expressions in the same curves chart

sunny_talwar — Wed, 16 May 2018 11:06:18 GMT

Abdallah Sekrafi wrote:

I mean 2 lines graphs

Re: 2 expressions in the same curves chart

absekrafi — Wed, 16 May 2018 11:09:37 GMT

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.

Re: 2 expressions in the same curves chart

sunny_talwar — Wed, 16 May 2018 11:11:55 GMT

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?

Re: 2 expressions in the same curves chart

absekrafi — Wed, 16 May 2018 12:53:58 GMT

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).

Re: 2 expressions in the same curves chart

bc-thebruuu — Wed, 16 May 2018 12:57:25 GMT

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

only(BUDGETA)

Num(concat(distinct BUDGETA))

and may you share a test app?

Re: 2 expressions in the same curves chart

sunny_talwar — Wed, 16 May 2018 13:17:18 GMT

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

Re: 2 expressions in the same curves chart

absekrafi — Wed, 16 May 2018 15:21:15 GMT

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