create a record based on other records within the same dimension

[zwyne]

Hi everyone,

I have dimension called Business Area as below

Business Area

RoA

MIWI

Function

So what I want to achieve is 

Business Area

RoA

MIWI

Function

All

Where the record ALL ='ROA','MIWI,'Function'. 

I have tried this statement below but its's not working.

 if(Match([Business Area],'Function','RoA','MIWI'),'ALL',[Business Area]) as [Business Area2]

Regards

[bramkn]

Create a table with resident load on this one with Concat(distinct[business Area],',') as Business Area have it concatenate to the original table.

[zwyne]

Thank you for the response. How do I then create the record ALL? Should I write an if statement

[bramkn]

Ah Sorry, I read it wrong. You want to be able to select all and then have Qlik Select all possible values?

[zwyne]

I should be able to select ALL where ALL ='Function','RoA','MIWI' or select individuals records. If possible on the script or listbox