topic Re: Only show duplicates in chart in QlikView

Only show duplicates in chart

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

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 🙂

Re: Only show duplicates in chart

ogautier62 — Fri, 27 Jul 2018 08:41:10 GMT

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

Re: Only show duplicates in chart

pooja_prabhu_n — Fri, 27 Jul 2018 10:58:25 GMT

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

Re: Only show duplicates in chart

anitamelbye — Fri, 27 Jul 2018 10:59:01 GMT

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.

Re: Only show duplicates in chart

ogautier62 — Fri, 27 Jul 2018 11:22:02 GMT

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 :