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
