# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## Creating manual data points in combo chart?

I need to create a combo chart that shows the volume of 5 specific CPT codes compared to the national average. There are only a few data points for the national average (see below). Any way I can manually input the data below to create the line to overlay with my bar chart?

 New Pt Code Medicare 99201 7.10% 99202 45.40% 99203 43.90% 99204 3.50% 99205 0.20%
Tags (2)
1 Solution

Accepted Solutions
MVP

## Re: Creating manual data points in combo chart?

There are two approaches I can think of:

1) Load the Medicare values into a separate field, in the same table as the rest of the data, or a new table linked on PTCode.

2) Code the values in an expression like this:

pick(Match([PT Code],'99200','99201','99202','99203','99204','99205')

,'.07710','.4540','.4390','.0350','.0020')

Example attached (QV & QS) showing both solutions.

-Rob

http://qlikviewcookbook.com

3 Replies
Not applicable

## Re: Creating manual data points in combo chart?

if you whant show only this codes use expression below:

exemple

sum({<[New Pt Code]={">=99201","<=99205"}>} you field)

MVP

## Re: Creating manual data points in combo chart?

There are two approaches I can think of:

1) Load the Medicare values into a separate field, in the same table as the rest of the data, or a new table linked on PTCode.

2) Code the values in an expression like this:

pick(Match([PT Code],'99200','99201','99202','99203','99204','99205')

,'.07710','.4540','.4390','.0350','.0020')

Example attached (QV & QS) showing both solutions.

-Rob