How do i combine multiple field values into one final field.

tulabandula — Tue, 09 Oct 2018 12:14:16 GMT

Hi ,

I have one dimension called 'SUMMARY' so wanted to have an analysis based on the summary like how many tickets are related to Issue A,B,C,D....etc . altogether it required around 180 nested if conditions to get it by match or wild match qualifiers but Qlikview is not allowing us huge number of nested if's for creating one dimension hence created 3 calculated dimensions by splitting 60 search conditions as one Summary_one,Summary_two,Summary_three.

How do i have all the three dimensions value into one final_field like an example..

Summary_one={apple,orange}

Summary_two={Python,Perl}

Summary_three={Qlikview,Power BI}

I need a field to have all the above three dimension values into one.

Regards,

Sreeni.

Re: How do i combine multiple field values into one final field.

YoussefBelloum — Tue, 09 Oct 2018 12:17:42 GMT

Hi,

you're trying to do this on the script or on the front-end ?

Re: How do i combine multiple field values into one final field.

tulabandula — Tue, 09 Oct 2018 12:34:35 GMT

i have tried in both but Front End is not at all responding with 180 nested if's so now checking in the script level.

topic How do i combine multiple field values into one final field. in QlikView

How do i combine multiple field values into one final field.

Re: How do i combine multiple field values into one final field.

Re: How do i combine multiple field values into one final field.