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

How to make Both table display the same value ?

paulyeo11 — Sat, 05 Sep 2015 05:11:43 GMT

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

PrashantSangle — Sat, 05 Sep 2015 06:09:19 GMT

Hi,

use set anlysis in table1 instead of if statement

use below expression in Table1

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

Regards,

paulyeo11 — Sat, 05 Sep 2015 08:40:45 GMT

Hi Max

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

Paul

ecolomer — Sat, 05 Sep 2015 09:06:39 GMT

see this

paulyeo11 — Sat, 05 Sep 2015 09:36:39 GMT

Hi Enrigue

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

Thank a lot

Paul