topic compare if one variable is between two field objects in QlikView

compare if one variable is between two field objects

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello! Thank you first for taking the time to read this, and hope that you will be able to help me!

I am creating a dashboard where I have a variable the variable for dates of purchase and delivery. I separate the 365 days of the year into 52 week segments, and so I would like to see which week segement the date falls into. If you have any ideas on how I can compare one variable to two fields, I would greatly appreciate it!

Thank you!

Re: compare if one variable is between two field objects

vinieme12 — Wed, 14 Dec 2016 18:28:43 GMT

what do you want to achieve with this?

use the same logic you used to create the week numbers and compare with week numbers of those dates

Purchasedate = Week($(datevariable1))

Deliverydate = Week($(datevariable1))

Re: compare if one variable is between two field objects

Anonymous — Thu, 15 Dec 2016 10:02:11 GMT

Thank you Vineeth for your response!

Do you think that there is any way I could make this work using the trigger function? I would like to be able to plug in into a input box, the week number (or a specific day of the month) and then it only shows me the furniture bought inbtw in that period. The period will be dictated by pre-set definitions of what week is what period.

Thanks so much!

Re: compare if one variable is between two field objects

vinieme12 — Thu, 15 Dec 2016 10:04:07 GMT

Can you provide sample app / data?

Re: compare if one variable is between two field objects

MarcoWedel — Thu, 15 Dec 2016 22:19:01 GMT

Hi,

one solution without the need for variables or triggers might be:

//creation of sample data
tabSales:
LOAD *,
    DayName(PurchaseDate+Pow(Rand(),3)*100) as DeliveryDate;
LOAD RecNo() as ID,
    DayName(YearStart(Today())+Rand()*265) as PurchaseDate
AutoGenerate 20;

tabCalendar: 
LOAD *, 
    Day(Date) as Day, 
    WeekDay(Date) as WeekDay, 
    Week(Date) as Week, 
    WeekName(Date) as WeekName, 
    Month(Date) as Month, 
    MonthName(Date) as MonthName, 
    Dual('Q'&Ceil(Month(Date)/3),Ceil(Month(Date)/3)) as Quarter, 
    QuarterName(Date) as QuarterName, 
    Year(Date) as Year, 
    WeekYear(Date) as WeekYear;   
LOAD Date(MinDate+IterNo()-1) as Date 
While MinDate+IterNo()-1 <= MaxDate; 
LOAD Min(PurchaseDate) as MinDate, 
    Max(DeliveryDate) as MaxDate 
Resident tabSales;

tabLink:
IntervalMatch (Date)
LOAD Distinct
    PurchaseDate,
    DeliveryDate
Resident tabSales;

hope this helps

regards

Marco

Re: compare if one variable is between two field objects

Anonymous — Fri, 16 Dec 2016 11:11:40 GMT

Hi ,

Can you share sample documents.