Conditional color

[Anonymous]

Hello,

I would like to identify a formula to highlight the rate column if there are if the account number appears twice in the pivot table.

I think this can be achieved using the aggr(count function

Please see example attached.

Thanks,

Esther

[Anil_Babu_Samineni]

Perhaps any one of these?

Count({<[Acc No] = {"=Count([Acc No])>1"}>} Rate)

OR

Sum({<[Acc No] = {"=Count([Acc No])>1"}>} Rate)

[sumanta12]

Hi,

Is this what you need?

[devarasu07]

Hi,

try like this, also other way to find the duplicate easily by using the list box object Show Frequency option.

if( Count([Acc No])>1,Yellow(),White())

[Anonymous]

Yes, that is the desired outcome for by table in qlikview

[Anonymous]

Sorry my question has changed slightly. I have another example using qlikview. If one of the products appears twice in this case "Shoes" then i would like the colors "green and yellow ' to be highlighted in yellow. As you can see the label does not repeat in a pivot table so I am not sure which expression to use.

Thanks.