topic Re: Combine 2 columns in 1 in chart in QlikView

Combine 2 columns in 1 in chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hey, guys!
I'm trying to find out the answer to the task.

I have a document with main and alternative states. I make different selections and make some charts for visualization. As well I have to use the results, which are presented in chart for further investigation. I can easily put result into the straight table in several columns, but then I need to combine these 2 columns into 1. Is there any possible way to do this?

I have tried to use Concat() with "chr(1)" as a separator, but I havent got the correct result.

Important: as if I use alternative states I see no opportunity to make any script changes. Only dynamical memory.

Thanks

Elena

Re: Combine 2 columns in 1 in chart

sunny_talwar — Wed, 10 Aug 2016 07:28:57 GMT

Have you tried with &

FieldName1 & FieldName2

Re: Combine 2 columns in 1 in chart

swuehl — Wed, 10 Aug 2016 07:31:19 GMT

Concat() will aggregate rows of a resident table, not concatenate columns in a chart.

If your first column expression is

=Sum({StateA} Value)

and your second

=Sum({StateB} Value)

you can use the string concatenation operator & to concatenate the parts:

=Sum({StateA} Value) & chr(10) & Sum({StateB} Value)

Re: Combine 2 columns in 1 in chart

Anonymous — Wed, 10 Aug 2016 07:34:33 GMT

Hey, Sunny!
Yes, but it seems to make the same number of rows with the final output

MainAlt

where Main is value of Main state, and Alt - of Alternative state.

And I need to have some operation equal to Concatenate in Load Editor, but for dynamic data. So that I have final number of rows equal to sum of rows number of Field1 and Field2.

Re: Combine 2 columns in 1 in chart

ramasaisaksoft — Wed, 10 Aug 2016 07:35:10 GMT

Hi Elena,

Ex:- Load FirstName,

Lastname,

FirstName &' '&Lastname as Fullname

from ....xyz.xls;

Re: Combine 2 columns in 1 in chart

Anonymous — Wed, 10 Aug 2016 07:44:32 GMT

Hello, Stefan!
I have tried it once more, attach the picture to make clearer what i get with & and what I actually need.

Re: Combine 2 columns in 1 in chart

Anonymous — Wed, 10 Aug 2016 07:45:36 GMT

Hey, Rama!
Thank you for your reply, but it wont work for me as if I dont have option to change the script.

Re: Combine 2 columns in 1 in chart

swuehl — Wed, 10 Aug 2016 11:45:42 GMT

Maybe try the union operator + on your two sets, like

{StateA+StateB}

but it's unclear to me what you finally want to achieve.

Note that you are basically operating on the same record set, so if both states contain intersecting subsets, the union will not duplicate these record.

Re: Combine 2 columns in 1 in chart

Anonymous — Wed, 10 Aug 2016 12:39:27 GMT

The task is to organize dynamical processing of Mann-Whitney U-test based on 2 sets (alternative and main states in my case), which are selected by user in real time. The description of the algorithm says I have to combine both sets of values I have already received and then rank it.

I try to find more elegant solution, but still... no result.

Thank you for help, Stefan