Qlik Community

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
992017.10%
9920245.40%
9920343.90%
992043.50%
992050.20%

Tags (2)
1 Solution

Accepted Solutions

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://masterssummit.com

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)

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://masterssummit.com

http://qlikviewcookbook.com

Not applicable

Re: Creating manual data points in combo chart?

Rob - it worked beautifully!

7f2568d8d2f54ebdb2fd5f7c595b3c62.jpg

Gratitude.