Discussion Board for collaboration related to QlikView App Development.
I would like to ask you for any advice about the following issue:
I would like to count the different values that changes to a "Box" to a different one when I select two different dates as follows:
If I select 20170522 and 20170724 I would like to have the count of values exchanges between boxes in the following layout:
A -D --> 2 (for the selected dates there are two values that have changed from the box A to the box D)
B- D--> 1 (for the selected dates there is one value that has changed from the box B to the box D)
C- A--> 1 (for the selected dates there is one value that has changed from the box C to the box A)
Any advice/ idea?
Thanks in advance
=Aggr(FirstSortedValue(Box, Date) & ' - ' & FirstSortedValue(Box, -Date), Values)