topic ingore user selections for graph in QlikView

ingore user selections for graph

Fri, 27 Aug 2010 15:39:27 GMT

is there a way to ignore the user selections form the list boxes on a graph?

i have two graphs, the first graph i want updated based on user list box selections (Month\Year) and the second graph i want to be fixed i.e. shows all data for years 2009-2010 + 2010-2011irrespective of user Month\Year list box selection.

I have a feeling this is done by set analysis but there isnt much guidance on set analysis at present.

see image for exampleof both graphs as they are at present (both are updated byuser Month \ Year selection)

ingore user selections for graph

john_duffy — Fri, 27 Aug 2010 16:31:23 GMT

Hello.

You can use set analysis to accomplish this. An expression such as SUM({$<YYYYMM = {"*"}>} SALES) will sum SALES, ignoring any selections in a list box for YYYYMM.

ingore user selections for graph

Fri, 27 Aug 2010 17:59:57 GMT

hi john,

thanks for your soultion it worked fine.

The expression i used was:

COUNT({$<YEAR = {"*"}>}[SALES])

Do you also know how i could adapt this expression so that it includes all MONTH aswell??

I was thinking COUNT({$<YEAR = {"*"}>}[{$<MONTH = {"*"}>}SALES]) but this doesnt work

ingore user selections for graph

john_duffy — Fri, 27 Aug 2010 18:09:16 GMT

The syntax would be: COUNT({$<YEAR = {"*"},MONTH = {"*"}>} SALES)