Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kumarreddy257
Contributor

Qvd's from different sources

Hi,

I have 3 qvd's namely dim_account, dim_state and fact_lines.

account qvd is coming from sql server and rest of qvds are coming from oracle data base.

I have imported into QVW file made relationship between fact_lines and as well dim_account with correct pk and fk.

But if i pull any dimension column from account and expressions from fact, i haven't seen any data.

If i do list box for dim_account coulms there is data. is there any way to figure out this issue.

Pls help me on this issue

Regards,

Kumar

21 Replies
martynlloyd
Contributor III

Re: Qvd's from different sources

When you display the data, check if it is right aligned or left aligned.

You may be treating one as a number and the other as text, check for extra spaces etc.

Or export both to Excel and use EXACT() to compare them...

Marty.

Re: Qvd's from different sources

check with your expressions once and the table links . All the linking keys should be in same format .

Hope this helps you

kumarreddy257
Contributor

Re: Qvd's from different sources

Hi,

In expressions it is populating values, but in dimensions i couldn;t see any data. There is relation proper relationship between fact and dimensions and i have seen in table viewer.

kumarreddy257
Contributor

Re: Qvd's from different sources

I am able to see count date wise, but the problem with account QVD only.

sudeepkm
Valued Contributor III

Re: Qvd's from different sources

what is the subset ratio of your key field in both dim and fact?

Do you have a screenshot or a scrambled sample that you can share?

kumarreddy257
Contributor

Re: Qvd's from different sources

For fact table it is 0.05% and for dim 99.95%

kumarreddy257
Contributor

Re: Qvd's from different sources

this dim is coming from one source and fact is coming from another source. Is it possible to have two difference in one QVW file.

sudeepkm
Valued Contributor III

Re: Qvd's from different sources

0.05% is too less not sure how many records. but it seems there are bunch of field values not same across both the tables. unless you have matching or associated values your chart wont display anything.

I'm not saying the chart or expression or data is wrong but I think as per your subset ratio the dim to fact association is weak and not have enough amount of matching record.

MVP
MVP

Re: Qvd's from different sources

The key field - the field that connects your two tables - the dimension table and the fact table, will only match rows between the tables if the values match. So check why the values in the dimension don't match the values in the fact table. The fact table should have 100% subset ratio on the key field that goes to the dimension table.

Is it a date or timestamp in either of the source database columns? Maybe you need to do a Floor() to get the exact granularity of a full day...

Community Browser