topic Re: urgent requirement in QlikView

urgent requirement

Anonymous — Fri, 18 May 2018 05:31:41 GMT

i have a requirement

where i have two dimensions say,

x and y

there are around141 combination conditions of the two fields for which i need to create a concatenated field,

like ,

x='value1' and y='value2'

x='value1' and y='value3'

x='value1' and y='value4'

like this i have 14 values in x dimension and 14 in y dimension so there has to be possible all combinations for both field values,

if i write with if statement in sciprt it will bearound 14*14=196 conditions,

how i shud achieve this?

Re: urgent requirement

big_dreams — Fri, 18 May 2018 06:00:27 GMT

can you explain with sample data ??

and required output..

Re: urgent requirement

Anonymous — Fri, 18 May 2018 06:25:05 GMT

the output is the concatenated field ,

sample data is as above

Re: urgent requirement

Anonymous — Fri, 18 May 2018 07:20:09 GMT

can plz help as its a bit urgent requirement

Re: urgent requirement

jonathandienst — Fri, 18 May 2018 07:49:04 GMT

If you give a brief statement of your question as the title for your post, you are more likely to get useful help, than "Urgent Requirement". Anyway, this will put all the combinations into a variable. Adapt for your exact requirements:

T1:

LOAD x Resident Data;

Join(T1)

LOAD y Resident Data;

T2:

LOAD Concat('x=' & chr(39) x & chr(39) & ' and ' & chr(39) & y & chr(39), chr(10)) as Result

Resident T1;

Let vResult = Peek('Result');

DROP Table T1, T2;

Re: urgent requirement

Anonymous — Tue, 22 May 2018 13:10:37 GMT

this is giving me concatenated fields all in single row when taking a list box,

kindly help what to do