topic Re: Creating charts in QlikView

Creating charts

sayadutt — Tue, 31 Mar 2015 06:07:34 GMT

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

Re: Creating charts

Tue, 31 Mar 2015 06:19:11 GMT

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!

Re: Creating charts

sayadutt — Tue, 31 Mar 2015 06:24:06 GMT

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

Re: Creating charts

Tue, 31 Mar 2015 06:30:34 GMT

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

Re: Creating charts

Tue, 31 Mar 2015 07:21:22 GMT

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)

Re: Creating charts

sayadutt — Tue, 31 Mar 2015 08:44:12 GMT

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

Re: Creating charts

Tue, 31 Mar 2015 08:48:45 GMT

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)

Re: Creating charts

sayadutt — Tue, 31 Mar 2015 09:00:00 GMT

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"

Re: Creating charts

Anonymous — Tue, 31 Mar 2015 09:01:58 GMT

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

Re: Creating charts

sayadutt — Tue, 31 Mar 2015 09:17:03 GMT

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

Re: Creating charts

Tue, 31 Mar 2015 09:23:06 GMT

Hi ,

sorry can check now