Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

philmywallet
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

Tags (2)
1 Solution

Accepted Solutions
tresesco
Not applicable

Re: Set analysis include filter

May be using intersection operator '*' like:

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

5 Replies
tresesco
Not applicable

Re: Set analysis include filter

May be using intersection operator '*' like:

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

philmywallet
Not applicable

Re: Set analysis include filter

Perfect.

Thanks

sunny_talwar
Not applicable

Re: Set analysis include filter

Read more on this topic here

Implicit Set Operators

yurgelmartina
Not applicable

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

sunny_talwar
Not applicable

Re: Set analysis include filter

Do what to the two expressions? Can you elaborate?