Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gayatri7
Creator II
Creator II

Chart for comparing the 2 measures with 1 dimesion

Hi All,

I need to create chart as shown below. I am not able to create the same. Chart is been created in Excel I wanted to create the same in Qlikview

Chart.PNG

1 Solution

Accepted Solutions
Kushal_Chawda

Create Bar chart

Dimension:

1) ValueList('Paid Amount','Claim Amount')

2) [Nombre Comercial]

Expression:

=pick(match(ValueList('Paid Amount','Claim Amount'),'Paid Amount','Claim Amount'),

sum([Control Period Paid Amount])/sum(TOTAL [Control Period Paid Amount]),

sum([Control period Claim Volume])/sum(TOTAL [Control period Claim Volume]))

Capture.JPG

View solution in original post

5 Replies
Kushal_Chawda

Please share the sample data

gayatri7
Creator II
Creator II
Author

Hi,

    Please find the sample Data.

  here Nombre Commercial[Hospital Name] as Dimension and Paid Amount and Claim Volume as Measure.

Kushal_Chawda

Create Bar chart

Dimension:

1) ValueList('Paid Amount','Claim Amount')

2) [Nombre Comercial]

Expression:

=pick(match(ValueList('Paid Amount','Claim Amount'),'Paid Amount','Claim Amount'),

sum([Control Period Paid Amount])/sum(TOTAL [Control Period Paid Amount]),

sum([Control period Claim Volume])/sum(TOTAL [Control period Claim Volume]))

Capture.JPG

gayatri7
Creator II
Creator II
Author

Thank u so much !!!!

Really appreciate ur quick response.

Kushal_Chawda

No problem