Discussion board where members can get started with Qlik Sense.
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.
I didn't check the attached qvf, but it can be some reason:
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
The First table at the sheet:
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.