Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Jdance
New Contributor II

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

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 
NameDate1 NameDate2  NameDate1
AJan-17 AMar-17  AMay-17
AMay-17 BJan-17  AOct-17
AOct-17 CAug-17  BFeb-17
BFeb-17     BJul-18
BJul-18     CSep-18
CMar-17       
CSep-18       
CApr-17       
1 Solution

Accepted Solutions
shruthibk
Contributor

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

please find the attached solution

1 Reply
shruthibk
Contributor

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

please find the attached solution