Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Perhaps any one of these?
Count({<[Acc No] = {"=Count([Acc No])>1"}>} Rate)
OR
Sum({<[Acc No] = {"=Count([Acc No])>1"}>} Rate)
Hi,
Is this what you need?
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())
Yes, that is the desired outcome for by table in qlikview
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.