Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Good/Expired might be interpreted as a division of Good by Expired instead of a field [Good/Expired]
I meant that, sorry it's just an example of the name of the field
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
Can you post a qlikview document that demonstrates the problem?