Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to combine values in one Field under one value

Hi All,

 

I have a Donut chart with the following expression 

Count({<[Status] *= {'Complete', '*Planned 2020', 'Planned 2021', 'Pending'}>} ID)

For some views, its important that the Planned 2020 & Planned 2021 values are umbrellas under one field (lets call it 'Planned')

Can someone advise me on how to make this possible?

 

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hello !

I guess you should create a new dimension "Status group' like the following:

=if(SubStringCount([Status], 'Planned')=1, 'Planned', [Status])

And then add this dimension to your donut.

Fanny

View solution in original post

1 Reply
Highlighted
Partner
Partner

Hello !

I guess you should create a new dimension "Status group' like the following:

=if(SubStringCount([Status], 'Planned')=1, 'Planned', [Status])

And then add this dimension to your donut.

Fanny

View solution in original post