Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ishanbansal1204
New Contributor

Excluding Filters in the expressions

Hi ,

I have an expression to calculate last 12 months of information.

count(DISTINCT{$<WEEK=,MON=,QUAR=,SUBMIT_DATE={">=$(=MonthStart(AddMonths(Max(SUBMIT_DATE),-12)))<$(=MonthEnd(Max(SUBMIT_DATE)))"}>} [ID])

As I have 3 filters in sheet 1 that is Week , Mon,Quar , whenever i apply these filters the value in the sheet 2 changes. is there any way that i can exclude filters in the expressions. appreciate your help.

Thank you.

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Excluding Filters in the expressions

Try,

count(DISTINCT{$<WEEK=,MON=,QUAR=,SUBMIT_DATE={">=$(=MonthStart(AddMonths(Max({<WEEK=,MON=,QUAR=>}SUBMIT_DATE),-12)))<$(=MonthEnd(Max({<WEEK=,MON=,QUAR=>}SUBMIT_DATE)))"}>} [ID])

2 Replies
shraddha_g
Honored Contributor III

Re: Excluding Filters in the expressions

Try,

count(DISTINCT{$<WEEK=,MON=,QUAR=,SUBMIT_DATE={">=$(=MonthStart(AddMonths(Max({<WEEK=,MON=,QUAR=>}SUBMIT_DATE),-12)))<$(=MonthEnd(Max({<WEEK=,MON=,QUAR=>}SUBMIT_DATE)))"}>} [ID])

ishanbansal1204
New Contributor

Re: Excluding Filters in the expressions

Thank you Shraddha.