topic Re: create a record based on other records within the same dimension in Water Cooler

create a record based on other records within the same dimension

zwyne — Wed, 09 Jan 2019 09:59:22 GMT

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 — Wed, 09 Jan 2019 10:24:40 GMT

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 — Wed, 09 Jan 2019 10:51:22 GMT

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

bramkn — Wed, 09 Jan 2019 10:59:08 GMT

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

zwyne — Wed, 09 Jan 2019 11:06:21 GMT

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