Creating charts

[sayadutt]

Hi Team,

I have a pretty simple requirement of creating 2 charts, one pivot table and another is line chart.

below is the data I have:

Division      ProjectName     End Year     Compliance

xxx             A                         2015         Compliant

xxx             B                         2014         NonCompliant

yyy             C                         2015         NA

xxx             D                       2015         NonCompliant

....

....

I need to create below 2 charts:

1) Pivot chart

It should show me following fields

Division   countofCompliant     countofNonCompliant     countofNA     %Compliant(total)      %compliant(2014)     %compliant(2015)

2) Line Chart

It should show in percentage over the year 2014 to 2015 -  how much the percentage change was.

I mean, lets say in 2014 %complaint was 50% , now in 2015 its 70%; in 2014 %Noncomplaint was 50% now in 2015 its 30%

(numbers are just examples)

Can you please help me with these please.

I am very new to qlikview.

Thanks

[#2]

Hi ,

sorry can check now