Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dhernandez95
New Contributor

Problem when displaying data

Good morning ... I have been working recently with Qlik Sense but the following problem arises:

I have a star model (fact table and its dimensions) with their respective associations, the problem is when I want to show the name of the stores (dimension) it does not show them, it shows them as if they were null but instead if I show the keys of these businesses, works without problem.

Any help you can give me regarding this situation?

1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: Problem when displaying data

Looks like keys are not getting associated with your store dimension table. Check if fieldnames are different in dimension and fact table. Share your data model in case this is not the problem you have.

6 Replies

Re: Problem when displaying data

better you post your screen shot of your table viewer and also possible your qvf.

Regards

Regards,
Prashant Sangle
Digvijay_Singh
Honored Contributor III

Re: Problem when displaying data

Looks like keys are not getting associated with your store dimension table. Check if fieldnames are different in dimension and fact table. Share your data model in case this is not the problem you have.

sjaiswal13
New Contributor II

Re: Problem when displaying data

Do you have inner join or left join between the store and the fact?It would be easy to understand this issue, if you have give an example of one id with its name from store and respective record from fact.

sas_fundm
New Contributor II

Re: Problem when displaying data

Did you've checked that your store-table and the fact-table use the same fieldname, e.g. "Store_ID"?

And don't forget: fieldnames are case-sensitive, therefore "Store_ID" isn't the same as  "Store_id"

regards, Stephan

dhernandez95
New Contributor

Re: Problem when displaying data

Thank you all.


The problem was that the data type did not match, in one table it was of integer type and in another of string type.


correcting this, it worked perfectly


Thanks

Digvijay_Singh
Honored Contributor III

Re: Problem when displaying data

You may now close this thread by marking correct/helpful answers as many as you want.

Community Browser