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,

Is it possible for you to attach sample data, because I want to see distribuition of projects over the years. How would you count complaints/non-complaints, in order to compute % ( as it looks like there is one unique record per project per year).

Thanks!

[sayadutt]

Hi,

I just gave a portion of the record.

here is the big list.

Division      ProjectName     End Year     Compliance

xxx             A                         2015         Compliant

xxx             B                         2014         NonCompliant

yyy             C                         2015         NA

xxx             D                         2015         NonCompliant

xxx             F                         2015         Compliant

xxx             E                         2014         NonCompliant

yyy             G                         2015         NA

zzz             H                         2015         NonCompliant

zzz             X                         2015         Compliant

xxx             Y                         2014         NonCompliant

yyy             X                         2015         NA

xxx             Z                         2015         NonCompliant

[#4]

Hi Dutta

I have attached the file with Pivot Table

Please check it and i need some clarity on Line Chart Requirement

See the Attachment

[#5]

Hi,

In Pivote chart, at Dimension tab,

                                              Division                

In Expression tab,

1. count({<Compliance={'Compliant'} >}  Division)    = countofCompliant

2. count({<Compliance={'NonCompliant'} >} Division)      =countofNonCompliant

3. count({<Compliance={'NA'} >} Division)   =countofNA

4. count({<Compliance={'Compliant'} >} Division) /count( Compliance)    =%Compliant(total)

5. count({<Compliance={'Compliant'} , [End Year]={'2014'} >} Division)/ count( Compliance)     =%compliant(2014)    

6. count({<Compliance={'Compliant'} , [End Year]={'2015'} >} Division)/ count( Compliance)    =  %compliant(2015)

[sayadutt]

Hi naidu,

I am getting syntax error when using your mentioned expression.

Will it be possible for you to give to attach the qlikview file here.

Thanks

[#7]

Hi,

You can use only this expressions.

1. count({<Compliance={'Compliant'} >}   Division)

2. count({<Compliance={'NonCompliant'} >}  Division) 

3. count({<Compliance={'NA'} >} Division

4. count({<Compliance={'Compliant'} >} Division) /count( Compliance)

5. count({<Compliance={'Compliant'} , [End Year]={'2014'} >} Division)/ count( Compliance)      

6. count({<Compliance={'Compliant'} , [End Year]={'2015'} >} Division)/ count( Compliance)  

[sayadutt]

in my file:

Compliance = [Compliance Status  ]

Division = [Application  ]

so the expression I am using is: (your 1st expression)

count({<[Compliance Status  ]={'Compliant'} [Application  ]>}

it is giving "error in set modifier expression"

[Anonymous]

it should be count({<[Compliance Status ]={'Compliant'}>} [Application ])

[sayadutt]

Hi Greeshma,

will it be possible for you to give a qlikview file with the solution.

what I am looking for:

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)

sample table:

Division      ProjectName     End Year     Compliance

xxx             A                         2015         Compliant

xxx             B                         2014         NonCompliant

yyy             C                         2015         NA

xxx             D                         2015         NonCompliant

xxx             F                         2015         Compliant

xxx             E                         2014         NonCompliant

yyy             G                         2015         NA

zzz             H                         2015         NonCompliant

zzz             X                         2015         Compliant

xxx             Y                         2014         NonCompliant

yyy             X                         2015         Compliant

xxx             Z                         2015         Compliant