# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Contributor

## Mark redundancy in chart

Hi All,

I want to mark configs (combination of parameter1 to parameter5) that are redundant within team and globally.

I am able to mark configs that are redundant within a team:

But I didn't find right formula to mark configs that are redundant globally

Expected (for same selections as above i.e. team A is selected):

Kindly help!

Thanks,

Kinjal

Tags (2)
1 Solution

Accepted Solutions
MVP

## Re: Mark redundancy in chart

Try this

If(count( {<Team>}distinct total

<

//Team,

parameter1,

parameter2,

parameter3,

parameter4,

parameter5> IDS) > 1 and count(distinct total

<Team,

parameter1,

parameter2,

parameter3,

parameter4,

parameter5> IDS)<=1 and Team = Team,'X')

3 Replies
MVP

## Re: Mark redundancy in chart

Try this

If(count( {<Team>}distinct total

<

//Team,

parameter1,

parameter2,

parameter3,

parameter4,

parameter5> IDS) > 1 and count(distinct total

<Team,

parameter1,

parameter2,

parameter3,

parameter4,

parameter5> IDS)<=1 and Team = Team,'X')

Contributor

## Re: Mark redundancy in chart

Thanks Sunny!

It is working

Can you explain what you did here?

MVP

## Re: Mark redundancy in chart

Two things

1) Ignored selection in Team for your existing condition because if you don't then the condition will honor your current selection of Team and will count within Team A only. Whereas you wanted to count across all teams

2) Since you only need the X on the second row... to remove the Xs from 3rd and 4th row... I gave the opposite of the 1st condition so that it doesn't satisfy and doesn't place X for where it already have

3) Left Team = Team by mistake... I think it should still work without that condition