Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to make Both table display the same value ?

Hi All

I have Table 1 and Table 2

Expression for Table 1 :-

sum(if(rEVENUE='rEVENUE',Amount/1000))

Expression for Table 2 :-

sum((Amount/1000))

Why when Table 1 and 2 display different value ? Since i have already manually turn on rEVENUE=rEVENUE.

How to make it display the same ?

Paul

1 Solution

Accepted Solutions
ecolomer
Honored Contributor II

Re: How to make Both table display the same value ?

see this

4 Replies

Re: How to make Both table display the same value ?

Hi,

use set anlysis in table1 instead of if statement

use below expression in Table1

Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

Regards,

Regards,
Prashant Sangle
paulyeo11
Valued Contributor II

Re: How to make Both table display the same value ?

Hi Max

I have try your expression , but the bar never appear.

Paul

ecolomer
Honored Contributor II

Re: How to make Both table display the same value ?

see this

paulyeo11
Valued Contributor II

Re: How to make Both table display the same value ?

Hi Enrigue

I found the issue , it is due to my QVW doc label is 1 REVNUE not rEVENUE.

Thank a lot

Paul

Community Browser