In the below script, I have to display only amount2 from table2 for any key values. But if amount2 not present then amount 1 from table1. Unfortunately I am getting both amount1 and amount2 when both are greater than zero for any key. I have attached my sample application, kindly share your ideas.
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!
