topic Re: Interval between dates with variable condition in QlikView

Interval between dates with variable condition

Claudiu_Anghelescu — Sat, 16 Nov 2024 19:28:28 GMT

Hi,

I need a point, I want to calculate the interval between 2 dates for each ID.

For example I want to have the interval where Status=S1 and Status=S6, so 04/12/2019 - 06/12/2019.

But the status will be changed based on input variable.

A solution is to create a new Date field for each status in Load Script, but I want to sort out in a different way.

Thanks in advance!

Re: Interval between dates with variable condition

PrashantSangle — Thu, 12 Dec 2019 10:57:24 GMT

what is your expected w.r.t above data data...

Re: Interval between dates with variable condition

Vegar — Thu, 12 Dec 2019 11:02:44 GMT

What about usin set analysis.

See attached qvw file.

Re: Interval between dates with variable condition

Claudiu_Anghelescu — Thu, 12 Dec 2019 12:03:48 GMT

The result is correct in the table but if I want to show it in a BarChart or TextBox, Only() is not working properly because aggregate at the lowest level.