Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Set analysis include filter

May be using intersection operator '*' like:

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

View solution in original post

5 Replies
MVP
MVP

Re: Set analysis include filter

May be using intersection operator '*' like:

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

View solution in original post

Highlighted
Creator
Creator

Re: Set analysis include filter

Perfect.

Thanks

Highlighted

Re: Set analysis include filter

Read more on this topic here

Implicit Set Operators

Highlighted
Contributor
Contributor

Re: Set analysis include filter

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')

Highlighted

Re: Set analysis include filter

Do what to the two expressions? Can you elaborate?