Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

wonkymeister
Contributor

Display all Issue

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

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Display all Issue

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

View solution in original post

3 Replies
Partner
Partner

Re: Display all Issue

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

View solution in original post

wonkymeister
Contributor

Re: Display all Issue

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.

Partner
Partner

Re: Display all Issue

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