Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
berryandcherry6
Not applicable

Displaying rows multiple times in Table

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.

Tags (1)
5 Replies
undergrinder
Not applicable

Re: Displaying rows multiple times in Table

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
Not applicable

Re: Displaying rows multiple times in Table

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
Not applicable

Re: Displaying rows multiple times in Table

Hi Supriya,

As soon as possible, I dwelve into your qvf.

G.

berryandcherry6
Not applicable

Re: Displaying rows multiple times in Table

HI undergrinder ,

Can you please look into .qvf file.

i am not getting what should be done for that

undergrinder
Not applicable

Re: Displaying rows multiple times in Table

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.