Display all Issue

[wonkymeister]

Morning,

I have a table with Year (showing 3 years) as the dimension and I want to display all of the relevant information attributed to the years.

The problem I have is that Year also exists as a selector with only one value selected (so can only select on year at a time).

So as an example, at present with a year selected the table looks like:

2010
2011	25	10	3	1	14	89	1
2012

No data displaying for 2010 or 2012. I need to force these values through.

Any ideas?

cheers

[agilos_mla · Accepted solution]

Use a set analysis in the chart expression

ie : count({<Year=>} Issue  

The syntax {<Year=>} will do the count but disregarding the Year selection, then all years will appear.

Michael

[wonkymeister]

Thanks Michael, works a treat!

so by passing "Year=" in the expression it forces through all the values regardless of which Year is selected.

learnt a new thing today

thanks again Michael.

[agilos_mla]

It's just a basic case with set analysis. Nice reading at :

http://community.qlik.com/docs/DOC-4951

It will give an rather exhaustive overview of what's possible with the set analysis.

Rgds,

Michael