Remove Duplication in Straight table in UI

[vlakeshr]

Hi Dear,

I ma facing duplication entry in Straight table in UI . Below is data script. VS_ID is Primary Key.

I cannot share the data due to security purpose.

I have create drilldown in Straight table as

VS_Name --> SVS_Name--> Objects_Name-->Outcomes with their Progress percentage.

I am getting duplication on VS_Name level hence getting duplicate value on SVS_Name as well

VS_Name is Parent, SVS_Name is Child and Objects and Outcomes are sub child.

I have used Composite Key but it's not helpful. 

AUTONUMBER ([VS DB ID] &'|'& [VS ID] &'|' &[VS Name]) as Check,

Can you please suggest how can avoid duplicate in UI level.

Table1:

VS_Name,

VS_ID,

DB_ID,

Current_Status,

Next_Periodstatus

etc..

Table2:

VS_Name,

VS_ID,

DB_ID,

SVS_Name

SVS_ID,

Current_Status,

Next_Periodstatus

etc..

Table3:

VS_Name,

VS_ID,

DB_ID,

SVS_Name

SVS_ID,

Objects_Name,

Objects_Current_Status,

Objects_Next_Periodstatus,

Progress,

Outcomes

etc..

[Luffy1326]

will it be possible to add qvw file for an example

[vlakeshr]

For Data Security..Can not share the data or QVD or QVW..

Below is Hierarchy

VS name can consider as Organization

SVS name can consider as Companies

Objects name can consider as Offices

Outcomes

[vlakeshr]

I have ben used below Link table URL to remove the synthetic Key but still facing duplication issue in UI in straight table. Any one can help me to resolve this issue

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/ 

[vlakeshr]

Hi  Dear All,

I have create Link table and near to solve this issue but I am facing issue as I am not getting current status and Next period status while create the Link table. Status are also included in Link table but not in the compound key.

Due to the Link table concatenate process, I am not able to get Current status and Next period status in Straight table. by using below URL create link table but status are not reflecting in straight table,

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/  

anybody can help me to resolve this issue...

Appreciate for early reply..

[vlakeshr]

any update on above request