topic Re: Data Mismatch? in QlikView

Data Mismatch?

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am new to qlikview.. I am facing one issue,

I have two QV applications

APP1 and APP2..

APP1 : i have two Text objects like Product A sales and Product B sale

Textobject 1: 22

TextObject2: 33

I have created new one that is APP2..

Same as above..

Textobject 1: 22

TextObject2: 33

req: I have filter like MONTH

When i select month -> PRODUCT A and Product B sales change

Now when i compare Both APPS -- APP1 and APP2 the values are difference 0.1,

Why?

How can i rectify it?

Thanks

Surya.

Re: Data Mismatch?

trdandamudi — Fri, 23 Sep 2016 15:30:04 GMT

Is it possible to attach a sample for both apps...

Re: Data Mismatch?

Thu, 29 Sep 2016 11:06:48 GMT

Hi All,

I have two apps with below data table:

APP1:

Table:1

ID, Sales

1, 200

6, 300
7, 0

8, 0

Results

Sum(Sales)=600

Count(ID) = 4

AVG(Sales) = 150

APP2:

Table:1

ID, Sales

1, 200

6, 300
7, 0

8, 0

Results:

Sum(Sales)=600

Count(ID) = 4

AVG(Sales) = 300

Here When i go with APP2 where Sales is '0' is not count in AVG Expression...

Can anyone please help me asap.