Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stefan_fischer
New Contributor II

Concatenate formulas

Hi,

how  can i concatenate to formulas? First I have if terms, that retrieve value1 without Null. Additional the second value2 should be ingegrated after if()...

=aggr(concat(if(value1='NULL','',value1)), name)

+

value2 = { $(=if (vVariable = 1,'a','b'))}

Regards

Stefan

9 Replies
MVP
MVP

Re: Concatenate formulas

Some more details about your data (like INPUT data and your expected results), as well as the context might be helpful.

Maybe like this?

=aggr(concat(if(value1='NULL','',value1 & if(vVariable=1,'a','b') )) , name)


or

=aggr(concat(if(value1='NULL','',value1)) & if(vVariable=1,'a','b') , name)

stefan_fischer
New Contributor II

Re: Concatenate formulas

I will attached an example.

stefan_fischer
New Contributor II

Re: Concatenate formulas

If you click on ∑ gross  or ∑ net comment should be change

MVP
MVP

Re: Concatenate formulas

Ok, but change to what? What is the comment you expect e.g. for Europa or Italien in either case?

stefan_fischer
New Contributor II

Re: Concatenate formulas

In dependency of gross / net. Europe with 'gross' have comment: 'EAP...'. Europe with 'net' have comment 'Null'

MVP
MVP

Re: Re: Concatenate formulas

This seems to have nothing to do with your original request (concatenation of formulas) and it really would help if you could post some more details about your requirements (well, it's up to you, I am giving up for now).

Here is a solution that fulfills your latest request (though I think it's not really what you want).

preminqlik
Valued Contributor II

Re: Re: Concatenate formulas

hi stefen ,

i didnt get you what you exactly mean ...but according to my understanding i have done some changes

please find attchment

regards

Premhas

stefan_fischer
New Contributor II

Re: Concatenate formulas


Please find attached the right example.

stefan_fischer
New Contributor II

Re: Re: Concatenate formulas

Please find attached the right example.

Community Browser