Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
aroberts90
Not applicable

Multiple selections in Set Analysis

We use Fiscal Year and Fiscal Period to define years and months respectively. Using the function below I'm able to return the YTD numbers based on the Fiscal Year selected in the filter pane above the table. The typical user selects a period and year though. How can I modify this expression to ignore the Fiscal Period filter when applied?

sum({$<[Fiscal Year]={"$(=Only([Fiscal Year]))"}>} [Sales])

1 Reply
sunny_talwar
Not applicable

Re: Multiple selections in Set Analysis

May be this:

Sum({$<[Fiscal Year]={"$(=Only([Fiscal Year]))"}, [Fiscal Period]>} [Sales])