Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
kinjal1645
Contributor

Mark redundancy in chart

Hi All,

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

Capture.GIF

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

Capture.GIF

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):

Capture.GIF

Kindly help!

Thanks,

Kinjal

Tags (2)
1 Solution

Accepted Solutions

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')

Capture.PNG

3 Replies

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')

Capture.PNG

kinjal1645
Contributor

Re: Mark redundancy in chart

Thanks Sunny!

It is working

Can you explain what you did here?

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