topic Re: Data not Matching in QlikView

Data not Matching

Wed, 04 Nov 2015 12:52:53 GMT

Hi All,

I want to know answer for couple of question asked in Interview.
Can some one tell me.

1) there is some discrepancy in Dashboard Value and in Database.
what is the reason and how will you track?

2) 2 Person is accessing same QVD and one user is unable to make changes in that. Reason?

3) Can you pass values in hyperlink and how?

Re: Data not Matching

oknotsen — Wed, 04 Nov 2015 15:14:46 GMT

1) The scripter made mistake in his/her load script.

Test with a good test set to make sure this is not the case.

2) 2 persons should never be accessing the same QVD at the same time. You are either mixing up QVD's with QVW's or you failed to organize your reload schedules correct.

--> So question to you: Are you sure you mean QVD's?

3) Please specify what you are trying to achieve. In other words: What is the actual use case? What is the problem you are trying to solve? What is the actual question?

Re: Data not Matching

Wed, 04 Nov 2015 17:37:45 GMT

2) yes my question was for QWD, but is it possible to have same scenario in QVW?

3) I want to pass parameters/ Variable values from one file to another using hyperlink.
is it possible?

Re: Data not Matching

oknotsen — Wed, 04 Nov 2015 18:50:43 GMT

When two different users are using your QVDs at the same time, your architecture or reload structure is setup wrong.

What you do is schedule your reloads on your server in such a way that reloads using those QVDs don't start before a reload creating the QVDs is done.

QVWs are never used by multiple users at the same time when using a server. They get loaded into the memory once and all users get a set a session on that.

Look up "document chaining". You can forward the "state" of an app (the selection) to a newly opened session on a different app. No need for "hyperlinks" or whatever.

Re: Data not Matching

oknotsen — Wed, 04 Nov 2015 22:07:27 GMT

Since you liked my latest reply but did not post a new question: Did all your questions get answers?

If so, please flag a Correct and Helpful answer.

If not, please post your still related and open questions.