How to avoid Duplicate Records

[bhavvibudagam]

Hi Every one,

Can any one please help me on below Requirement.

In My pivot table i have the data like below in Group and Metric Dimensions.

The Met35.1,Met35.2 records in Metric field is assigned to only SAP and Operations Group.

But requirement is need to show those two records only to SAP group only and the restriction should be on SAP Group and Met35.1,Met35.2 Records in Metrics remaining all the records need to be keep same as it is the Duplicate records are applied only to SAP Group.

[jonathandienst]

Simply exclude the 'operations' Group values in the load script: where Group <> 'operations'

or in the front end expression: Sum({<Group -= {'operations'}>} ... )

[sunny_talwar]

May be like this

If((Count(DISTINCT TOTAL <Metric> Group) = 2 and Group = 'SAP') or Count(DISTINCT TOTAL <Metric> Group) = 1, YourExpression)

[bhavvibudagam]

Hi Sunny,

I have tried above expression. But its not working. What does 2, 1 Indicates?

[sunny_talwar]

Count of Groups within a Metric

[bhavvibudagam]

Hi Sunny,

Thanks for your reply. Actually I don''t have the measures in the table all are the dimensions.

I need to restrict at dimension level Only.

When the Operation = Met 35.1 and Met 35.2 then I need to remove the records.

When Operation= Met 35.6 then I need to keep it same as it is.

Please help me on above restriction.

[sunny_talwar]

No expression? Are you using Qlik Sense or Qlik View?

[bhavvibudagam]

Qliksense

[sunny_talwar · Accepted solution]

May be this for BusinessGrouping Dimension

Aggr(If((Count(DISTINCT TOTAL <Metric> Group) = 2 and Group = 'SAP') or Count(DISTINCT TOTAL <Metric> Group) = 1, BusinessGrouping), BusinessGrouping, Metric)

[bhavvibudagam]

Thank you so much Its working