topic IF statments for Groups in App Development

IF statments for Groups

Loeckli — Wed, 27 Jul 2022 08:57:02 GMT

Hello everyone,

I have the following table in the code snippet it's the second_load,

Name	Status	Start	End
Tiger	release	07.06.2022	17.06.2022
Tiger	rejected	07.06.2022	13.06.2022
Fish	release	12.05.2022	22.05.2022
Frog	release	07.04.2022	12.04.2022
Frog	rejected	07.04.2022	10.04.2022

Frist_Load: Load Name, Status, Date(max(End)) as End, Date(min(Start)) as Start Resident Final Group by Name, Status; Second_Load: NoConcatenate Load Name, Status, Start, Ende Resident Frist_Load; Drop Table Frist_Load;

What i want to achieve is ; To Group the same animal name and if in this group there is a status rejected, calucate the duration with the start date of the rejected until the end point of the released row. Else there is no status rejected within the name groups calculate the duration end-start.

How would you code this problem in Qliksense ?
Thanks in advance for your time and help

Re: IF statments for Groups

MarcoWedel — Wed, 27 Jul 2022 17:09:25 GMT

do you want to calculate in the front end or the script?

what would your expected result be using your sample data?

Re: IF statments for Groups

Loeckli — Thu, 28 Jul 2022 09:23:57 GMT

What is best suited, what is my absolute end goal with this data. Is a graph, on the X-axis the calendar weeks in which the end date lies and on the Y-axis the average lead time of all name groups.

Name	Duration	Enddate	CW
Tiger	10 days	17.06.2022	24 CW 2022
Fish	10 days	22.05.2022	22 CW 2022
Frog	5 days	12.04.2022	15 CW 2022