topic Re: Concatenating String in QlikView

Concatenating String

vijetas42 — Fri, 19 May 2017 13:21:34 GMT

I have two output of project code which are string so, how can I concatenate them and make a action in select field of text box

expression is,

count(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Phase]-={'Cancelled','Complete'},

[RAG]={'G'}>}[Code])

count(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Display_Phase]={'Open'},

[RAG]={'G'}>}[Code])

I have tried to write action in text box as,

'('&concat(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Phase]-={'Cancelled','Complete'},

[RAG]={'G'}>}[Code],'|')&')'

'('&concat(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Display_Phase]={'Open'},

[RAG]={'G'}>}

,'|')&')'

but didn't work.

Please suggest!

TIA

Re: Concatenating String

sunny_talwar — Fri, 19 May 2017 13:26:00 GMT

May be this

='(' & Concat(DISTINCT {<[Code] = {"=Sum($(vSale))/1000000 >0"}, [Phase] -= {'Cancelled','Complete'},

[RAG] = {'G'}>+<[Code] = {"=Sum($(vSale))/1000000 >0"}, [Display_Phase] = {'Open'},

[RAG] = {'G'}>} [Code],'|') & ')'

or may be this

='(' & Concat(DISTINCT {<[Code] = {"=Sum($(vSale)) > 0"}, [Phase] -= {'Cancelled','Complete'},

[RAG] = {'G'}>+<[Code] = {"=Sum($(vSale)) > 0"}, [Display_Phase] = {'Open'},

[RAG] = {'G'}>}

,'|') & ')'

Re: Concatenating String

tresB — Fri, 19 May 2017 13:26:33 GMT

May be this:

'('&

concat(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Phase]-={'Cancelled','Complete'},

[RAG]={'G'}>}[Code],'|')

& '|' &

concat(DISTINCT {<[Code]={"=sum($(vSale))/1000000 >0"},[Display_Phase]={'Open'},

[RAG]={'G'}>}

,'|')

&')'

Note, few corrections in parenthesis and highlighted section.

Re: Concatenating String

jonathandienst — Fri, 19 May 2017 13:34:16 GMT

Not sure how vSales is defined - as liong it is not supposed to work row by row - you could try

'(' & Concat(DISTINCT {<[Code] = {"=sum($(vSale))/1000000 >0"}, [Phase] -= {'Cancelled','Complete'}, [RAG]={'G'}>} Code,'|')

& '|' &

& Concat(DISTINCT {<[Code] = {"=sum($(vSale))/1000000 >0"}, [Display_Phase] = {'Open'}, [RAG]={'G'}>} Code,'|') & ')'

Or perhaps a single expression rather than the compound one above:

'(' & Concat(DISTINCT {<[Code] = {"=sum($(vSale))/1000000 >0"}, [RAG]={'G'}> * (<[Phase] -= {'Cancelled','Complete'}> + <[Display_Phase] = {'Open'}>)} Code,'|') & ')'