Only show duplicates in chart

[anitamelbye]

Hi,

I have the following data:

The chart is showing the value from the the last three periodes, and the sum column is the sum pr transaktion-date.

I would like to only show the one's that are duplicates but not the other ones. (Or maybe highlight the duplicates in the chart if that is easier). I am kind of new to QV, so an easy solution to this is very much appreciated 🙂

[ogautier62]

Hi,

how do you consider it's duplicate ?

these are lines for same ansrn which have same amount in one of the three columns ?

regards

[pooja_prabhu_n]

Hi,

you can use above function to identify the duplicate row

=IF( Ansnr = Above(TOTAL Ansnr),IF( Sum(LA1260_Antall_1805+LA1260_Antall_1806+LA1260_Antall_1807) = ABOVE(TOTAL Sum(LA1260_Antall_1805+LA1260_Antall_1806+LA1260_Antall_1807)),

1,0))

Thanks,

Pooja

[anitamelbye]

Hi, Olivier, thank you for you respond!

Yes, you are correct, if the same value appears in one of the three columns then it is a duplicate. See also the same value in the last sum pr transactiondate, the same value appears two times on the same ansnr.

Sorry for not being precise enough in my first question.

[ogautier62]

not quite simple,

just achieve to make a chart which display ansnr with duplicate and duplicate line separated by *

replace in the example below NoTicket2 by ansrn

and ID2 with your row ID

with data like that :