Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
riseup319
New Contributor

Creating a new field based on values from existing field

Hi,

I have an existing field called 'Status' that contains essentially four data values: Completed, In Progress, Accepted, and Created.

I want to display the counts for the value of 'Completed' and then a separate count for the values of the other 3 ('In Progress', 'Accepted', 'Created'). 

 

Is there a simple way to create this as a dimension to display side-by-side bars displaying counts for each? Any help is greatly appreciated, I am just starting out!

1 Solution

Accepted Solutions
Vegar
Honored Contributor

Re: Creating a new field based on values from existing field

Try to make a bar chart with the Status as a dimension and =count(Status) as measure.

If you prefer not to use the Status as an dimension in order to put the measure in a KPI object then you could use a set expression like this:

=count( {<Status={'In Progress'}>}Status)

PS: I would recommend you to put program related questions like this into one of the sections in the Qlik Product Forums. That part of the community are better monitored by your fellow Qlik product developers.
Please ekskuse my Norglish and Swenglish typos.
4 Replies
Vegar
Honored Contributor

Re: Creating a new field based on values from existing field

Try to make a bar chart with the Status as a dimension and =count(Status) as measure.

If you prefer not to use the Status as an dimension in order to put the measure in a KPI object then you could use a set expression like this:

=count( {<Status={'In Progress'}>}Status)

PS: I would recommend you to put program related questions like this into one of the sections in the Qlik Product Forums. That part of the community are better monitored by your fellow Qlik product developers.
Please ekskuse my Norglish and Swenglish typos.
Community Manager
Community Manager

Re: Creating a new field based on values from existing field

@riseup319  Are yo using Qlik Sense or View?  I would like to move this into the correct product forum as this one is typically for general discussions. 

Sue Macaluso
riseup319
New Contributor

Re: Creating a new field based on values from existing field

QlikSense and that would be great, I will make note of correct forum to post questions like this.

riseup319
New Contributor

Re: Creating a new field based on values from existing field

Thanks this worked perfectly: Count({<Status={'In progress' , 'Accepted' , 'Shipment created'}>}Status)