Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set analysis include filter

Hi

This should be an easy one ....

I need to include my data for anything after 04th September 2017.  However as I select a filter the set analysis fixes the selection.  How do I include the selection whilst maintaining the set analysis.  e.g.  If I select 22/10/17 I need the other dates to be removed from my chart.

Here is my expression

PK_Date={'>=04/09/2017'}

Thanks in advance

1 Solution

Accepted Solutions
tresesco
MVP
MVP

May be using intersection operator '*' like:

PK_Date*={'>=04/09/2017'}

View solution in original post

5 Replies
tresesco
MVP
MVP

May be using intersection operator '*' like:

PK_Date*={'>=04/09/2017'}

Anonymous
Not applicable
Author

Perfect.

Thanks

sunny_talwar

Read more on this topic here

Implicit Set Operators

yurgelmartina
Contributor
Contributor

Hello,

I needed to do two expressions but not very familiar with the sintax...

Could you please help me not working.

=if(sum({$<Dia =  {'13/05/2018'} >} StockLoja) > sum({$<Dia =  {'16/04/2018'} >} StockBuffer),'1','0')


=if(sum({$<Dia =  {'13/05/2018'} >} StockLoja) > sum({$<Dia =  {'16/04/2018'} >} StockBuffer),

sum({$<Dia =  {'13/05/2018'} >} StockLoja)-sum({$<Dia =  {'16/04/2018'} >} StockBuffer,

'0')

sunny_talwar

Do what to the two expressions? Can you elaborate?