topic Re: Variable date range calculation in Set Analysis in QlikView

Variable date range calculation in Set Analysis

christiana — Sat, 16 Nov 2024 02:56:30 GMT

Dear all,

I'm trying to set up a layout with date calculations within the Set Analysis.

Background: user should be able to choose a key date and the AR overdue date ranges he wants to look at.

Example: Key date is 31.05.2019, the AR overdue ranges are 30, 60 and 90.

My formula looks currently like this:

sum({<DueDate={">=($(vKeyDate)-$(vCateg2)) <=$(vKeyDate)-$(vCateg1) "}>} Amount)

in Words: the sum of the field amount should be calculated when the duedate is greater than 01.04.2019 and less than 01.05.2019.

What am I doing wrong?

Many thanks for your help!

dplr-rn — Mon, 22 Jul 2019 16:07:20 GMT

Move the calculation to a single variable

e.g. $(vKeyDate)-$(vCateg2) to vKeyDateLow

and change expression to

Sum({<DueDate={">=$(=vKeyDateLow) <=$(=vKeyDateMax)"}>} Amount)

christiana — Tue, 23 Jul 2019 09:09:03 GMT

Unfortunately I'm not able to make it work.

I have attached a sample qvw file.

Any idea what is going wrong?

sunny_talwar — Tue, 23 Jul 2019 11:49:18 GMT

Look at the attached

christiana — Mon, 29 Jul 2019 16:04:49 GMT

Many many thanks to you!

I transfered it to my Qlikview application and it is working!

Thanks a lot for your quick support and help!