Script to add column to table using minimum value

kpark06334 — Sat, 16 Nov 2024 03:48:44 GMT

Hi,

I'm new to Qlickview and I need to add a columns to the table loaded that has calculated minimum value each time a variable change. MinVal, StartDate column below is what i'm looking for. MinVal stores minimum VALUE for each corresponding NAME. StartDate stores first date with value corresponding to the NAME. Thank you for your help.

NAME	DATE	VALUE	MinVal	StartDate
A	1/1/2019		1.00	2/1/2019
A	2/1/2019	1.00	1.00	2/1/2019
A	3/1/2019	2.00	1.00	2/1/2019
B	1/1/2019	5.00	5.00	1/1/2019
B	2/1/2019	6.00	5.00	1/1/2019
C	3/1/2019	3.00	3.00	3/1/2019
C	4/1/2019	4.00	3.00	3/1/2019
C	5/1/2019	5.00	3.00	3/1/2019

Re: Script to add column to table using minimum value

albertovarela — Thu, 18 Apr 2019 16:23:41 GMT

Take a look at the attached qvw.

I hope it helps...

Re: Script to add column to table using minimum value

kpark06334 — Thu, 18 Apr 2019 17:37:53 GMT

Thank you!

topic Script to add column to table using minimum value in QlikView

Script to add column to table using minimum value

Re: Script to add column to table using minimum value

Re: Script to add column to table using minimum value