topic Re: Re: Concatenate formulas in QlikView

Concatenate formulas

Anonymous — Sat, 04 Jan 2014 15:57:38 GMT

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

Re: Concatenate formulas

swuehl — Sat, 04 Jan 2014 16:25:02 GMT

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)

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

Re: Concatenate formulas

Anonymous — Sat, 04 Jan 2014 17:03:04 GMT

I will attached an example.

Re: Concatenate formulas

Anonymous — Sat, 04 Jan 2014 17:06:06 GMT

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

Re: Concatenate formulas

swuehl — Sat, 04 Jan 2014 17:40:39 GMT

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

Re: Concatenate formulas

Anonymous — Sat, 04 Jan 2014 17:57:29 GMT

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

Re: Re: Concatenate formulas

swuehl — Sat, 04 Jan 2014 18:53:31 GMT

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).

Re: Re: Concatenate formulas

preminqlik — Sat, 04 Jan 2014 19:01:18 GMT

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

Re: Concatenate formulas

Anonymous — Sat, 04 Jan 2014 19:21:24 GMT

Please find attached the right example.

Re: Re: Concatenate formulas

Anonymous — Sat, 04 Jan 2014 19:23:11 GMT

Please find attached the right example.