topic Re: Set analysis include filter in QlikView

Set analysis include filter

Anonymous — Tue, 31 Oct 2017 09:50:08 GMT

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

Re: Set analysis include filter

tresB — Tue, 31 Oct 2017 10:00:54 GMT

May be using intersection operator '*' like:

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

Re: Set analysis include filter

Anonymous — Tue, 31 Oct 2017 10:04:05 GMT

Perfect.

Thanks

Re: Set analysis include filter

sunny_talwar — Tue, 31 Oct 2017 11:24:47 GMT

Re: Set analysis include filter

yurgelmartina — Sat, 19 May 2018 13:04:45 GMT

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

Re: Set analysis include filter

sunny_talwar — Mon, 21 May 2018 15:03:26 GMT

Do what to the two expressions? Can you elaborate?