Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
PurplePills555
Contributor III
Contributor III
‎2019-03-18 12:46 PM

Set Analysis Include Exclude with Date Condition

Hi All,

I have the following scenario. I have 3 Fields. Type, Month_Numeric, Score.

Type is made of Assessments and Closures.

A selection will be made for a particular month say Jan 2019. I need to sum the scores for the closures for that date selection (Sum Score for Closures in January) but also include All Assessments from the beginning of time in the Sum. Date doesn't matter for Assessments.

So Sum will be  Type='Closures ' AND Month_Numeric=GetCurrentSelection(MonthNumeric) + Sum of All Type='Assessment' For All Months from history.

Whats the best way to go about this?

208 Views
0 Likes
1 Reply
dplr-rn
Partner - Master III
Partner - Master III
‎2019-03-18 01:15 PM

Not 100% clear on your needs but from what i understand
using total qualifier might help
e.g. Sum(Total Score) or Sum(Total<Type> Score)
https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990

If you can share sample data and desired output i can try to help further.
201 Views