Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Mismatch?

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.

2 Replies
trdandamudi
Master II
Master II

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

Not applicable
Author

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.