topic Re: error string combination in QlikView

error string combination

Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

How can i combine the 2 expression together to achieve this outout:

V1 (7.6) Vs V2 (8.9)

=Subfield(GetFieldSelections([Vessel/Voy]),',',1)&' Vs '&''&sum({$<[Vessel/Voy]={'$(v1)'}>}PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]={'$(v1)'}>}CNTR_N),''##,###.#'')

=Subfield(GetFieldSelections([Vessel/Voy]),',',1)&' Vs '&''&sum({$<[Vessel/Voy]={'$(v2)'}>}PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]={'$(v2)'}>}CNTR_N),''##,###.#'')

Re: error string combination

swuehl — Sat, 05 Nov 2016 10:14:43 GMT

You can use the concatenation operator & to concatenate two strings (and remove the second equal sign). Also check your quoting, I think the format code of the num() function should be embedded in single quotes only.

=Subfield(GetFieldSelections([Vessel/Voy]),',',1)&' Vs '&''&sum({$<[Vessel/Voy]={'$(v1)'}>}PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]={'$(v1)'}>}CNTR_N),'##,###.#')

Subfield(GetFieldSelections([Vessel/Voy]),',',1)&' Vs '&''&sum({$<[Vessel/Voy]={'$(v2)'}>}PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]={'$(v2)'}>}CNTR_N),'##,###.#')

edit:

Wait, where are the functions like num that used the format code at all. I've added num() functions.

=Subfield(GetFieldSelections([Vessel/Voy]),',',1)&' Vs '&''&Num(sum({$<[Vessel/Voy]={'$(v1)'}>}PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]={'$(v1)'}>}CNTR_N),'##,###.#')

Subfield(GetFieldSelections([Vessel/Voy]),',',1)&' Vs '&''&Num(sum({$<[Vessel/Voy]={'$(v2)'}>}PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]={'$(v2)'}>}CNTR_N),'##,###.#')

Re: error string combination

Anil_Babu_Samineni — Sat, 05 Nov 2016 10:23:42 GMT

What does the value you are getting for this, And can you provide the values of [Vessel/Voy]

SubField(GetFieldSelections([Vessel/Voy]),',',1) -- If This is V1

=Subfield(GetFieldSelections([Vessel/Voy]),',',1)& ' ' & '(' & Num(sum({$<[Vessel/Voy]={$(=Subfield(GetFieldSelections([Vessel/Voy]),',',1))}>} PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]=>}CNTR_N),''##,###.#'') & ')' & ' ' & ' Vs ' &

Subfield(GetFieldSelections([Vessel/Voy]),',',1)& ' ' & '(' & Num(sum({$<[Vessel/Voy]=>} PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]=>}CNTR_N),''##,###.#'') & ')'

Note: I didn't understand the $(v1) & $(v2)

=Subfield(GetFieldSelections([Vessel/Voy]),',',1)& ' ' & '(' & Num(sum({$<[Vessel/Voy]={'$(v1)'}>} PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]={'$(v1)'}>}CNTR_N),''##,###.#'') & ')' & ' ' & ' Vs ' &

Subfield(GetFieldSelections([Vessel/Voy]),',',1)& ' ' & '(' & Num(sum({$<[Vessel/Voy]={'$(v2)'}>} PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]={'$(v2)'}>}CNTR_N),''##,###.#'') & ')'

Note: I've added NUM Function here

Re: error string combination

Sat, 05 Nov 2016 10:34:06 GMT

Hi Anil

Pls see attached , doesnt work with the NUM function.

Re: error string combination

swuehl — Sat, 05 Nov 2016 10:58:47 GMT

The problem with the num() function is the incorrect quoting of the format code. use single quotes only:

=Subfield(GetFieldSelections([Vessel/Voy]),',',1)& ' ' & '(' & Num(sum({$<[Vessel/Voy]={'$(v1)'}>} PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]={'$(v1)'}>}CNTR_N),'##,###.#') & ')' & ' ' & ' Vs ' &

Subfield(GetFieldSelections([Vessel/Voy]),',',1)& ' ' & '(' & Num(sum({$<[Vessel/Voy]={'$(v2)'}>} PM_WAIT_TIME_Q) / Count ({$<[Vessel/Voy]={'$(v2)'}>}CNTR_N),'##,###.#') & ')'

Re: error string combination

Sat, 05 Nov 2016 11:07:39 GMT

Thanks but the missing num in v2 ()

Re: error string combination

Frank_Hartmann — Sat, 05 Nov 2016 11:12:39 GMT

try this:

Subfield(GetFieldSelections([Vessel/Voy]),',',1)& ' ' & '(' & Num(sum({$<[Vessel/Voy]={'$(v1)'}>} PM_WAIT_TIME_Q) /

Count ({$<[Vessel/Voy]={'$(v1)'}>}CNTR_N),'##,###.#') & ')' & ' ' & ' Vs ' &

Subfield(GetFieldSelections([Vessel/Voy]),',',2)& ' ' & '(' & Num(sum(aggr(sum(PM_WAIT_TIME_Q) /

Count (CNTR_N),[Vessel/Voy]))-sum(aggr(sum({$<[Vessel/Voy]={'$(v1)'}>}PM_WAIT_TIME_Q) /

Count ({$<[Vessel/Voy]={'$(v1)'}>}CNTR_N),[Vessel/Voy])),'##,###.#') & ')'

hope this helps!

Re: error string combination

Sat, 05 Nov 2016 11:15:30 GMT

superb 😃

Re: error string combination

Frank_Hartmann — Sat, 05 Nov 2016 11:20:22 GMT

Im glad that it works 🙂

Please close the thread by marking correct answer. It will help others (who browse for the similar problem) to find the solution.