topic Re: Problems with exclusion using set analysis in QlikView

Problems with exclusion using set analysis

Anonymous — Fri, 15 May 2015 15:43:49 GMT

Hello,

I'm having a problem that I hope you can help me with:

I have the following data:

I want to select all of the ProductType= Fruit when my actual Date (2015) is higher or iqual than DateStart and Lower or iqual than DateExpiration and exclude the ones that are Expired.

So far my expression syntax is like this:

=count({<ProductType={'Fruit'}, DateStart={"<=$(vActualDate)"}, DateExpiration={">=$(vActualDate)"}> - <ProductType={'Fruit'}, DateStart={"<=$(vActualDate)"}, DateExpiration={">=$(vActualDate)"}, Good/Expired={'Expired'}>} ProductName)

Everything works until the exclusion ( " - " ), what would be the correct syntax?

Thanks a lot

Re: Problems with exclusion using set analysis

Gysbert_Wassenaar — Fri, 15 May 2015 15:48:10 GMT

Good/Expired might be interpreted as a division of Good by Expired instead of a field [Good/Expired]

Re: Problems with exclusion using set analysis

Anonymous — Fri, 15 May 2015 15:49:50 GMT

I meant that, sorry it's just an example of the name of the field

Re: Problems with exclusion using set analysis

Fri, 15 May 2015 15:54:20 GMT

Hi Francisco,

Is there a reason why you cannot solely use your Good/Expired field to give you this? Just exclude out the expired data?

i.e Count({<ProductType={'Fruit'},[Good/Expired]={'Good'}>} ProductName)

or can you have 'good' that hasn't started yet?

If so create a flag in the script to help you. Something like

Load

If(Year(today())>=[DateStart] And Year(today())<=[DateExpiration],1) As GoodInDate_Flag

Count({<ProductType={'Fruit'},GoodInDate_Flag={1},[Good/Expired]={'Good'}>} ProductName)

hope that helps

Joe

Re: Problems with exclusion using set analysis

Gysbert_Wassenaar — Fri, 15 May 2015 16:03:48 GMT

Can you post a qlikview document that demonstrates the problem?