Displaying rows multiple times in Table

[berryandcherry6]

I am trying to display datas from database,i have displayed three column rows from same table it is working fine,Now i need to add a quick_tips_client_id from USERS table,if i had quick_tips_client_id  to it,Rows getting repeated or unique_user_id gets repeated for same quick_tips_client_id ,even if that user is not under that client.

I have checked database,one unique_user_id has single client.Please help me on this.I am very new to qliksense.

I have attached my working sample, Please  check into that.

[undergrinder]

Hi Supriya,

I didn't check the attached qvf, but it can be some reason:

• Underlying data set. The user table and the other table have one to many relationship.
• At the visualisation you are choosing so dimensions that have one to many relationship.
• The relationship beetween tables isn't definied (check  the data model viewer), I don't know, if it can be a problem with dimensions, with measure it is sure a problem.

G.

[berryandcherry6]

Hi undergrinder ,

Thanks for your reply.

In my sample i am using 3 kind of tables

1.)user table - table using for purpose to get details from quicktips table according to user_id,here each user as clients and each client have different user.

2.)client table - to get client id for users

3.)quicktips tables - get details according to user_id from quick tips table.

Here each client will be  having  different user.so there is no one to many relationship,as every user_id will be having its client and getting details according to user_id.

Please look into qvf file and please help me on this

[undergrinder]

Hi Supriya,

As soon as possible, I dwelve into your qvf.

G.

[berryandcherry6]

HI undergrinder ,

Can you please look into .qvf file.

i am not getting what should be done for that

[undergrinder]

Hi Supriya,

The First table at the sheet:

• quick_tips_question_id
• unique_user_id
• user_answer

All fields are from USERQUICKTIPSANSWERS table.

Please look at your data model.

The USERQUICKTIPSANSWERS  table connect to QUICKTIPSQUESTIONS on  quick_tips_question_id

The QUICKTIPSQUESTIONS table connect to USERQUICKTIPS on quick_tips_id

The USERQUICKTIPS table connect to USERS on quick_tips_userid. (Users table contains quick_tips_client id)

These connections have an key change, the connections aren't proper defined.

Try that to comprehend the problem:

Add quick_tips_id to the table on the top (based on QUICKTIPSQUESTIONS table),

You can see, that all value is the same (133).

Add quick_tips_user_id (based on USERQUICKTIPS)

And you see it have a wrong relation.

Hope this helps.

G.