topic Re: Mark redundancy in chart in QlikView

Mark redundancy in chart

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

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

Re: Mark redundancy in chart

sunny_talwar — Tue, 10 Jul 2018 16:09:34 GMT

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

Re: Mark redundancy in chart

kinjal1645 — Tue, 10 Jul 2018 19:22:01 GMT

Thanks Sunny!

It is working

Can you explain what you did here?

Re: Mark redundancy in chart

sunny_talwar — Tue, 10 Jul 2018 19:24:53 GMT

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