Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. 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
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
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