Set Analysis Include Exclude with Date Condition

PurplePills555 — Mon, 18 Mar 2019 16:46:53 GMT

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?

Re: Set Analysis Include Exclude with Date Condition

dplr-rn — Mon, 18 Mar 2019 17:15:29 GMT

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.

topic Re: Set Analysis Include Exclude with Date Condition in QlikView

Set Analysis Include Exclude with Date Condition

Re: Set Analysis Include Exclude with Date Condition