topic Calculate all row values in QlikView

Calculate all row values

Athira_K — Wed, 09 Feb 2022 06:21:03 GMT

Hello
I have a pseudocode and can someone help me change it to qlikview code?
stop and start are timestamps,F=0 or 1,Variable =4
diff=0,
for(i<variable)
if(F=0)
diff=(stop-start)+diff
else
diff=(stop-start)+diff
break

Re: Calculate all row values

Davis69 — Thu, 10 Feb 2022 04:38:26 GMT

@EmployeeConnection wrote:

Hello
I have a pseudocode and can someone help me change it to qlikview code?
stop and start are timestamps,F=0 or 1,Variable =4
diff=0,
for(i<variable)
if(F=0)
diff=(stop-start)+diff
else
diff=(stop-start)+diff
break

Row name can have multiple levels, separated by the tilde (~} character, for use when there is more than one row name column in the report. For example, the calculated row name "Actual~Sales", if output (using PRINTROW) in a report with at least two row name columns, results in Sales in the right-most row name column, and Actual in the row name column to its left. If a multiple level row-name is used in a report with only one row-name column, only the rightmost part of the name appears in the report.

Re: Calculate all row values

MarcoWedel — Wed, 09 Feb 2022 20:16:56 GMT

maybe helpful:

https://community.qlik.com/t5/QlikView-App-Dev/Loop-Through-Computation/td-p/1890796

Re: Calculate all row values

Akeem — Fri, 11 Feb 2022 04:29:54 GMT

@MIBridges Login wrote:

Hello
I have a pseudocode and can someone help me change it to qlikview code?
stop and start are timestamps,F=0 or 1,Variable =4
diff=0,
for(i<variable)
if(F=0)
diff=(stop-start)+diff
else
diff=(stop-start)+diff
break

Correct if i understand you question wrong,

This is your formula: (999 * 25) + 100 -1 + (47/20)

You can write a expression like:

Expression 03:00 AM:

(Sum({<TestParameter={'pH(5-10)'}>}03:00 AM) * Sum({<TestParameter={'TSC % (20% - 50%)'}>}03:00 AM) ) + Sum({<TestParameter={'viscosity(cp)'}>}03:00 AM)-Sum({<TestParameter={'Particle Size(2.269um)'}>}03:00 AM)+(Sum({<TestParameter={'Seive Residue (45um)'}>}03:00 AM) / Sum({<TestParameter={'Seive Residue (20um)'}>}03:00 AM))

Expression 07:00 AM:

(Sum({<TestParameter={'pH(5-10)'}>}07:00 AM) * Sum({<TestParameter={'TSC % (20% - 50%)'}>}07:00 AM) ) + Sum({<TestParameter={'viscosity(cp)'}>}07:00 AM)-Sum({<TestParameter={'Particle Size(2.269um)'}>}07:00 AM)+(Sum({<TestParameter={'Seive Residue (45um)'}>}07:00 AM) / Sum({<TestParameter={'Seive Residue (20um)'}>}07:00 AM))

Expression 11:00 AM:

(Sum({<TestParameter={'pH(5-10)'}>}11:00 AM) * Sum({<TestParameter={'TSC % (20% - 50%)'}>}11:00 AM) ) + Sum({<TestParameter={'viscosity(cp)'}>}11:00 AM)-Sum({<TestParameter={'Particle Size(2.269um)'}>}11:00 AM)+(Sum({<TestParameter={'Seive Residue (45um)'}>}11:00 AM) / Sum({<TestParameter={'Seive Residue (20um)'}>}11:00 AM))

Thanks,