Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QlikCommunity, I know that QlikView table boxes filter duplicated records in such a way that if two records are identical on all points listed in the table box, the table box will only show one line for that record like so:
Records/Values in database might be like this:
User ID Date Minutes Uploaded
123 12/13/2013 50 12/14/2013
123 12/13/2013 50 12/15/2013
(Uploaded field isn't in my qvds, but I am guessing something like it is hiding somewhere or snuck through somehow.)
QlikView TableBox shows this
User ID Date Minutes
123 12/13/2013 50
QlikView Straight Chart shows this
User ID Date Minutes
123 12/13/2013 100
Now, how do I make a QlikView Straight Chart that sums in such a way as to only count duplicated records once? Mine is doing this currently for one group that had some kind of technical issue and might have been reloaded or might have something about two processes feeding the same data table or something. The issue seems to be persistent and consistent in causing my sums to show double the minutes actually logged. I'm hoping for some simple way to make my formula spin its sums of whatever QlikView is doing itself to handle the duplicate records. Thanks!
Hi Michael,
Concern according to your expression you are suppressing duplicates what if you want to show only duplicates
Thanks !! It worked for my case too, many thanks Michael!!