Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vishalgoud
Contributor III

counts are not matching though the qvds are same...???

Hi All,

facing very strange issue but was seriouly struggling with this issue.

we have 2 phases in the project i mean we have 2 Qlik apps, phase1 and phase2.

phase1 app contains the data till 2015 jan to 2017 Aug.

in Phase 2 app we have to show the same data as phase1 along with 2 new columns, that 2 columns are coming from the data from sep 2017 onwards.

in order to match the New qvds, we are adding the dummy column (with default value) to all the Phase1 Qvds(Fact Qvds)

one new column is coming from Fact table and other new column from Dimension table.

we are converting the all old qvds(Phase1 Qvds) into new qvds with addition of new column(dummy value).

after loading the new qvds into phase2 Qlik app, it has to perfectly match with the phase1 till Aug as we are loading the same Qvds.

but in my case they are not matching with the phase1 app...

please suggest some work arounds to solve this, alone in the team, Please help me.

was found that some thing wrong with the converted qvds which is causing the issue. by taking diff combinations like below

Fact QvdsDim QvdsResult /matching status with phase1 app
Phase2 QvdsPhase 2 QvdsNot Matching
Phase2 QvdsPhase 1 QvdsNot Matching
Phase 1 QvdsPhase 2 QvdsMatching

  with the above test we found that phase2 (converted qvds) are creating problem, but that conversion Qlik app is fine and same way i did for other apps it was perfect.

7 Replies
MVP
MVP

Re: counts are not matching though the qvds are same...???

Could you describe a bit more detailed

- how you have compared the numbers (based on what measures / fields)?

- how you have transformed your QVDs

- if you have compared your QVDs with other means (e.g. QViewer QVD Viewer or a record based source comparison)

vishalgoud
Contributor III

Re: counts are not matching though the qvds are same...???

thanks stefan for your reply,

phase1 Qlik app and phase2 Qlik app both are exactly same excpet 2 filters which we added as filters in phase 2.

- how you have compared the numbers (based on what measures / fields)? - they are same apps (with same exp and charts), just the only diff is new columns as filters in the UI, and they are mentioned in Backend script.

- how you have transformed your QVDs : using an another qlik app especially for this conversion , like loading the phase1 qvd and adding a new column like 'UNKNOWN' as TYPE. and storing them in the phase2 qvd path.

- if you have compared your QVDs with other means (e.g. QViewer QVD Viewer or a record based source comparison)

we dont have QViewer, was just checking the size of the Qvd, it is matching.

and just now i took one single Qvd from phase1 and the record count is 4121844.

and after adding the dummy column ('UNKNOWN' as TYPE), i mean the count of phase2 Qvd is also same i.e  4121844.

bit surprised to see this , that how after adding a new column as well the record count is same.

MVP
MVP

Re: counts are not matching though the qvds are same...???

Well, that's what we would expect, right? The number of records should be the same.

Still I haven't fully understood where the two versions differ exactly.

Could you post a screenshots of your two versions that show this difference?

vishalgoud
Contributor III

Re: counts are not matching though the qvds are same...???

the only difference is phase1 containt the data from 2015 jan to 2017 Aug.

where as Phase2 contains data from 2015 Jan to 2017 Dec. as per the project requirement 2 new columns comes from in data from sep 2017 to dec 2017.

so this is the only difference and attaching the pics from both the apps. PFA

we have 2 type of calendar months one is cohort moth and cohort year where as other is normal snapshot date.

cohort month and cohort year are data islands - means no connection with the any table in the data model though still data is filtering when we select something from cohort month and year. --- this is not clear to me


attaching the images to mail thread. Thanks again Stefan

MVP
MVP

Re: counts are not matching though the qvds are same...???

Can't see any images, can you recheck your attachments?

If selections on a data island table influence the other data, then either this is done in your chart expressions or using triggers with Select in field actions. Can you check the expressions and monitor the current selection status?

Besides this, I think I understood the difference between your data sets. My question was more about what difference in measures / results you've observed that let you think that the data update was not correct.

vishalgoud
Contributor III

Re: counts are not matching though the qvds are same...???

For attachments please check in the main question above.

highlighted the counts difference in phase2 app.

while preparing the phase2 app , i took a copy of phase1 and added 2 new columns in the backend, accordingly i did the changes in the phase2 extractor as well to get the new columns from sep 2017 to dec 2017.

where as for all old qvds (from 2015 jan to 2017 aug) have used the simple conversion technique.

based on more analysis observed couple of things today :

1. for few tables i can see more dim values in phase2.

ex: phase1 tables contains 3 categeries 100 value is distributed among those ,where as for phase2 i can see some additional categories where 110 devide across them....

but when i check both phase1 and phase2 dim qvds they are having same number  columns.

the above is repeated in couple of tables...

2. the attached pics show bit less difference but without selecting snapshot date if select same cohort month and cohort year in both apps, --- the difference is more --- no idea why we are getting the difference-- suspecting some thing worng with the these cohort calender fields..

in the attached images when i select same snapshot date from both apps without selecting any cohort date fields  we can see the only difference with cohortMO -- the same issue repeated almost in all tabs..

now i dont have any idea , how i can compare the both apps and how i can prove that both the apps are showing the same data..

vishalgoud
Contributor III

Re: counts are not matching though the qvds are same...???

hi stefan,

sorry for bringing the same thread to you, got some pointers for my above issue.

i found that one dim qvd called tariff type is changed from phase1 to phase2. phase1 tariff qvd contains 10894 records wher as phase2 tariff qvd contains 10974.

but i dont have a QVDviewer to see exactly where the difference is coming..

and i see some new columns coming in phase2 app which are not there in phase1, is that is because of the above qvd...

Thanks in advance.