Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am very new to QlikView (less than 2 weeks experience) and I am stuck with the following problem:
I have 2 different datasets loaded which are linked by a common field (Name) and then each data set has a field which contains a date (Lets say Dataset1 has a field called Date1 and Dataset2 has a field called Date2). I am looking to create a button that when clicked it will select/show only the cases from Dataset1 where Date1 > Date2 (similar to when you select a value from a list box).
It should also be mentioned that in Dataset1 there will be multiple different cases with the same Name but varying dates for Date1. I want to only look at the cases where Date1 > Date2 and there will only be maximum one case per name in Dataset2
I have included an example of what I am trying to achieve below (The two original datasets and the output dataset 1):
Dataset1 | DataSet2 | Dataset1 | ||||||
Name | Date1 | Name | Date2 | Name | Date1 | |||
A | Jan-17 | A | Mar-17 | A | May-17 | |||
A | May-17 | B | Jan-17 | A | Oct-17 | |||
A | Oct-17 | C | Aug-17 | B | Feb-17 | |||
B | Feb-17 | B | Jul-18 | |||||
B | Jul-18 | C | Sep-18 | |||||
C | Mar-17 | |||||||
C | Sep-18 | |||||||
C | Apr-17 |
please find the attached solution
please find the attached solution