Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

deerhunter
Contributor

Set Analysis Restriction

How can i limit a sum in set analysis for totaling quarter end monthly counts even if the user

picks multiple months from a filter box.

example: User picks (Jan, Fed, Mar) and only march counts get summed.

2 Replies
MVP
MVP

Re: Set Analysis Restriction

Maybe like

Count({<MonthField *= {'Mar','Jun','Sep','Dec'}>} FieldToCount)

Not applicable

Re: Set Analysis Restriction

Data:

Load * Inline

[

     Date, Value

    01-01-2016,100

    15-01-2016,10

    31-01-2016,10

    01-02-2016,20

    15-02-2016,34

    28-02-2016,45

    01-03-2016,78

    15-03-2016,90

    31-03-2016,200

];

//Make a variable for maximum date in variable overview

Let vMaxDate= Max(Date);

Expression would be :

IF(Num(Month(vMaxDate))%4=0,

Sum({<Date={">=MonthStart($(vMaxDate))<=MonthEnd($(vMaxDate))"}>} Value)

)