Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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
Kush
MVP
MVP

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
Kush
MVP
MVP

Please share the sample data

gayatri7
Creator II
Creator II

Hi,

    Please find the sample Data.

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

Kush
MVP
MVP

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

gayatri7
Creator II
Creator II

Thank u so much !!!!

Really appreciate ur quick response.

Kush
MVP
MVP

No problem