topic Re: How to avoid Duplicate Records in QlikView

How to avoid Duplicate Records

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to avoid Duplicate Records

jonathandienst — Mon, 23 Oct 2017 12:24:50 GMT

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

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

Re: How to avoid Duplicate Records

sunny_talwar — Mon, 23 Oct 2017 12:24:57 GMT

May be like this

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

Re: How to avoid Duplicate Records

bhavvibudagam — Mon, 23 Oct 2017 12:38:04 GMT

Hi Sunny,

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

Re: How to avoid Duplicate Records

sunny_talwar — Mon, 23 Oct 2017 12:43:57 GMT

Count of Groups within a Metric

Re: How to avoid Duplicate Records

bhavvibudagam — Mon, 23 Oct 2017 13:08:42 GMT

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.

Re: How to avoid Duplicate Records

sunny_talwar — Mon, 23 Oct 2017 13:14:54 GMT

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

Re: How to avoid Duplicate Records

bhavvibudagam — Mon, 23 Oct 2017 13:17:08 GMT

Qliksense

Re: How to avoid Duplicate Records

sunny_talwar — Mon, 23 Oct 2017 13:33:47 GMT

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)

Re: How to avoid Duplicate Records

bhavvibudagam — Mon, 23 Oct 2017 13:47:56 GMT

Thank you so much Its working