topic How to load without concatenate fields with same name in QlikView

How to load without concatenate fields with same name

QlickySense — Mon, 12 Jul 2021 10:58:33 GMT

Hello,

I got several tables where names are alike (not all, but lot of them). They not necessary represent same things so I dont want to concatenate them (and no one will convince me that its good thing in this scenario). Moreover, I know I can do something like '1' as XX in one table, '2' as XX in second table etc and then do set analysis in expression to count given variable where XX = 1 but what if I need variable (from certain able, not concatenated) as dimension?

I tried
Tab1:

Variables

Noconcatenate

Tab2:

Variables

and so on, but It didnt work for me

Any suggestions?

Re: How to load without concatenate fields with same name

Kushal_Chawda — Mon, 12 Jul 2021 11:21:00 GMT

@QlickySense try to wrap variables in single quotes '$(variable_name)'

Re: How to load without concatenate fields with same name

QlickySense — Mon, 12 Jul 2021 12:02:20 GMT

Each variable? and then put 'Table name' as TableName for each table and do set analysis as expression to identify from which table expression should be counted etc, but variables will remain unconcatenated so I can use them freely as dimension, once spotted in field list?

Re: How to load without concatenate fields with same name

Kushal_Chawda — Mon, 12 Jul 2021 16:24:36 GMT

@QlickySense Yes. you could do that. If you could also create some sample examples of your need then it will be helpful

Re: How to load without concatenate fields with same name

QlickySense — Tue, 13 Jul 2021 06:58:27 GMT

It didnt worked for me (the syntax completly omit the $(var name). okay I just managed to created every variable AS

Re: How to load without concatenate fields with same name

Mellissa468 — Wed, 14 Jul 2021 05:16:09 GMT

I'm also facing the issue, please help me to resolve this issue.

My Card Statement

Re: How to load without concatenate fields with same name

Kushal_Chawda — Wed, 14 Jul 2021 13:38:48 GMT

@QlickySense Please create some examples of what you are trying to do and what is expected