Creating a button that selects cases based off a condition of two fields

Jdance — Sat, 16 Nov 2024 21:21:14 GMT

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

Re: Creating a button that selects cases based off a condition of two fields

shruthibk — Mon, 25 Feb 2019 12:02:27 GMT

please find the attached solution

topic Creating a button that selects cases based off a condition of two fields in QlikView

Creating a button that selects cases based off a condition of two fields

Re: Creating a button that selects cases based off a condition of two fields