Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.