Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Allow filters except the one used in aggregation

Hello,


I am trying to accomplish following tasks on my data collection:


-Filter CreateDate By Today

-Ignore Any other filter on CreateDate

-Allow Any other filters to apply

-SUM(Quantity) for above

Ideally, intersection of following sets;

{$<CreateDate=>} --> Ignores Create Date filter, Yet allows other filters

{1<CreateDate={"$(=TODAY()"}>} --> Filters CreateDate by Today only

Not getting the results I need. Please advice.

9 Replies
Not applicable

Re: Allow filters except the one used in aggregation

Hi,

Might be you need to have use DATE function.

1)  Can you debug the CreateDate and Today in list box, either both are matching or not.

2) CreateDate should not be string, if it is string you need to have convert itinto date.

Thanks

sinanozdemir
Valued Contributor III

Re: Allow filters except the one used in aggregation

Hi,

The below expression should do what you are looking for:

Capture.PNG

Date is set to today's date and other filters can be applied to the table:

Capture.PNG

Hope this helps.

Re: Allow filters except the one used in aggregation

=SUM({<Date = {"$(=Date(Today()))"}>}Quantity)

Not applicable

Re: Allow filters except the one used in aggregation

This solution does not work for Filters on CreateDate. i.e. If I choose yesterday as a filter, the sum goes to 0.  I would like to

Ignore Any other date filter on the CreateDate Field. Any suggestions?

Re: Allow filters except the one used in aggregation

=SUM({<Month=, Year=, Quarter=, Date = {"$(=Date(Today()))"}>}Quantity)

Same way you can ignore all other filters..

Not applicable

Re: Allow filters except the one used in aggregation

Well, I actually don't want to ignore other filters. Only CreateDate Filter is what I want to ignore. e.g.

=SUM({<CreateDate=,CreateDate= {"$(=Date(Today()))"}>}Quantity)

which obviously doesn't work.

Re: Allow filters except the one used in aggregation

Provide sample application. The one which I have given first is working for my application...

Not applicable

Re: Allow filters except the one used in aggregation

Please read my original requirement. Your solution works partially. It does not satisfy requirement # 2

-Ignore Any other filter on CreateDate

Your solution below works when there is no filter on CreateDate.

=SUM({<CreateDate = {"$(=Date(Today()))"}>}Quantity)

If I choose CreateDate='1/1/2015', above total goes to 0, which is incorrect.

Hope this helps.

Re: Allow filters except the one used in aggregation

Without checking your application, I can't help further. Sorry..

May be you can create a dummy application with sample data and attach here.