Solved: Set Analysis or how to clear date - Qlik Community

Report Inappropriate Content · ‎2011-06-26

In the attached application "Daily Summary Tab" I am trying display production charts with all the dates versus only one date in the "Daily Summary" with out clearing the "Date" field so the other tabs have the individual dates selected. Any help or recommendations would be greatly appreciated.

Anonymous · ‎2011-06-26

If you simply want to disregard the Date field for your Oil/Gas/Water etc. chart expressions, you can add some set analysis to the expressions.

For example, change Sum(BOPD) to Sum({$<Date=>} BOPD) to keep the current selections, except for deselecting everything in Date.

View solution in original post

Anonymous · ‎2011-06-26

If you simply want to disregard the Date field for your Oil/Gas/Water etc. chart expressions, you can add some set analysis to the expressions.

For example, change Sum(BOPD) to Sum({$<Date=>} BOPD) to keep the current selections, except for deselecting everything in Date.

Report Inappropriate Content · ‎2011-06-26

Thank you Johannes, that did the trick.