Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

qvraj123
Contributor II

count difference between the reload and after opening the QVW file

Hi All,

Thanks for your time, i have this strange problem - i have a QVW file with few metrics - I reload the data from the QVD files

then count for one of the metric is 181,657 then i save the QVW file and close it. When I reopen the QVW file the count i see is like 76,000 - any one seen this behavior QV12 - what could be the reason

please, i really appreciate your time

1 Solution

Accepted Solutions
Partner
Partner

Re: count difference between the reload and after opening the QVW file

Yes, that's it. The reduction in REDUCTION_FIELD1 will affect your output when opening the qvw.

???
Celebrating my 300 accepted solution in the Qlik Community
???
6 Replies
qvraj123
Contributor II

Re: count difference between the reload and after opening the QVW file

 
qvraj123
Contributor II

Re: count difference between the reload and after opening the QVW file

hi all, any one has seen this.. why could be the reasons for value to be different after the reload and save qvw, close it and reopen the same file - after the reopen i see a diff value - thanks for your time

qvraj123
Contributor II

Re: count difference between the reload and after opening the QVW file

hi all, any one see such behavior- please suggest

Partner
Partner

Re: count difference between the reload and after opening the QVW file

This is probably due to section access. Please confirm that you have section access implemented in your application.

 

The reduction of section access is done when opening a document, after a reload you will see the full data set.

???
Celebrating my 300 accepted solution in the Qlik Community
???
Highlighted
qvraj123
Contributor II

Re: count difference between the reload and after opening the QVW file

Thank you Vegar - after a lot of head scratch - I really appreciate your time.

There is a field in the section called REDUCTION_FIELD1 which we also have in one of the data table as REDUCTION_FIELD1

and this means that the reduction applies only when the QVW file is opened - right? I can clearly see this difference

thanks a lot

Partner
Partner

Re: count difference between the reload and after opening the QVW file

Yes, that's it. The reduction in REDUCTION_FIELD1 will affect your output when opening the qvw.

???
Celebrating my 300 accepted solution in the Qlik Community
???