topic Display all Issue in QlikView

Display all Issue

wonkymeister — Mon, 03 Feb 2014 10:42:50 GMT

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:

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

Any ideas?

cheers

agilos_mla — Mon, 03 Feb 2014 10:46:24 GMT

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 — Mon, 03 Feb 2014 10:57:06 GMT

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 — Mon, 03 Feb 2014 11:03:50 GMT

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

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

Rgds,

Michael