Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

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

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.

2 Replies
YoussefBelloum
Esteemed Contributor

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

Hi,

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

Partner
Partner

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

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.