topic Re: Conditional color in QlikView

Conditional color

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

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

Re: Conditional color

Anil_Babu_Samineni — Fri, 17 Nov 2017 04:20:30 GMT

Perhaps any one of these?

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

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

Re: Conditional color

sumanta12 — Fri, 17 Nov 2017 05:23:09 GMT

Hi,

Is this what you need?

Re: Conditional color

devarasu07 — Fri, 17 Nov 2017 05:31:01 GMT

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

Re: Conditional color

Anonymous — Fri, 17 Nov 2017 13:25:00 GMT

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

Re: Conditional color

Anonymous — Sun, 19 Nov 2017 22:18:46 GMT

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.