Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Selection Issue

Hey All,

I have an issue -

I have a pie chart that has the expressions :

=count({<Q2LastYearScore = {1}>} responseid)/ count(Q2LastYearScore)

=count({<Q2LastYearScore = {2}>} responseid)/ count(Q2LastYearScore)

=count({<Q2LastYearScore = {3}>} responseid)/ count(Q2LastYearScore)

(where I,2 and 3 relate to different responses)


There are no dimensions.

I have a year filter which has the years 2011 and 2010.

When year is not selected it gives a set of results - lets say results A

When year 2011 is selected it gives set of results B

How would i script this pie chart to only show the 2011 data? and exclude 2010 and combined 2010 and 2011 data. As Year is not being used int he pie chart im lost on what to do.

IF further description - information requiered please let me know.

Thank you.

1 Solution

Accepted Solutions
MVP
MVP

Selection Issue

maybe like

=count({<Q2LastYearScore = {1}, year = {2011}>} responseid)/ count({<year = {2011}>} Q2LastYearScore)

etc.

where year is the field name for your year.

1 Reply
MVP
MVP

Selection Issue

maybe like

=count({<Q2LastYearScore = {1}, year = {2011}>} responseid)/ count({<year = {2011}>} Q2LastYearScore)

etc.

where year is the field name for your year.

Community Browser