Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

May be using intersection operator '*' like:

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

View solution in original post

5 Replies
Highlighted
MVP
MVP

May be using intersection operator '*' like:

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

View solution in original post

Highlighted
Creator
Creator

Perfect.

Thanks

Highlighted

Read more on this topic here

Implicit Set Operators

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

Highlighted

Do what to the two expressions? Can you elaborate?