Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Accepted Solutions
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]))
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]))
