topic Re: Compare two date ranges in QlikView

Compare two date ranges

scott_brown — Sat, 16 Nov 2024 00:26:19 GMT

I am trying to find a way to compare two different date ranges. For example, i need to have two columns in the same table for sum(sales), one containing DateRange1 and the other containing DateRange2, with the user being able to select which date ranges they want to compare. My date field is WeekEnding date, so i have one sales value for each week ending date.

I've created an alternate state 'CompareDate' and created a second WE_DATE listbox with the new alternate state, and an expression sum({CompareDate}Sales), however I need the remaining listbox filters to also apply to the same column.

Re: Compare two date ranges

vamsee — Tue, 23 Jun 2020 19:14:43 GMT

If I got your question right, I would suggest you use Alternate States .

Let's say you create two list boxes for [WeekEnding Date], one in Time1, other in Time2.

Create a chart with two expressions

1. Sum({Time1}Sales)

2. Sum({Time2}Sales)

Also refer Qlikfix Alternate-states

Re: Compare two date ranges

scott_brown — Wed, 24 Jun 2020 14:33:07 GMT

Hi Vamsee,

Re: Compare two date ranges

scott_brown — Wed, 24 Jun 2020 17:54:27 GMT

UPDATE: I ended up adding WE_DATE2 to the load script, taking values from the resident table where WE_DATE resides and creating a column with the expression: sum({$<WE_DATE=P(WE_Date2)>}Sales).