Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
agilos_mla
Contributor III

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

3 Replies
agilos_mla
Contributor III

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

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.

agilos_mla
Contributor III

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

Community Browser