topic Re: Remove Duplication in Straight table in UI in QlikView

Remove Duplication in Straight table in UI

vlakeshr — Thu, 22 Apr 2021 10:17:23 GMT

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..

Re: Remove Duplication in Straight table in UI

Luffy1326 — Thu, 22 Apr 2021 11:16:01 GMT

will it be possible to add qvw file for an example

Re: Remove Duplication in Straight table in UI

vlakeshr — Thu, 22 Apr 2021 11:24:39 GMT

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

Re: Remove Duplication in Straight table in UI

vlakeshr — Fri, 23 Apr 2021 07:20:50 GMT

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/

Re: Remove Duplication in Straight table in UI

vlakeshr — Mon, 26 Apr 2021 13:15:21 GMT

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..

Re: Remove Duplication in Straight table in UI

vlakeshr — Tue, 27 Apr 2021 08:49:18 GMT

any update on above request