Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

4 values into one

Hello

it is possible to make 4 different values into one?

eg on the picture i have 4 Closed values.

IS it possible to make one value called Closed which is a sum of them all??

Expression is atm.

=count({1<DimPotentialCustomers.RelationID=p({1<DimPotentialCustomers.RelationID={'11', '13','14','16','10','12'}>} DimPotentialCustomers.RelationID)>} DimPotentialCustomers.Company)

crm1.PNG

Tags (3)
1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: 4 values into one

Replace your chart dimenension with calculated dimensions, like this:

aggr((if(wildmatch(YourDimension, 'Closed*'), 'Closed', YourDimension), YourDimension)

Regards,

Michael

2 Replies
mov
Esteemed Contributor III

Re: 4 values into one

Replace your chart dimenension with calculated dimensions, like this:

aggr((if(wildmatch(YourDimension, 'Closed*'), 'Closed', YourDimension), YourDimension)

Regards,

Michael

Not applicable

Re: 4 values into one

Brilliant, just what i needed!! Thank you

Community Browser