Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have some criteria which consists of the following
G/L Number
10040,10041,10045,10050,10051,10055,10060,10061,10065,10100,10101,10105
Job No.
Industry Code
The idea is that:
IF G/L Number = 10040,10041,10045
AND Job No. -='' " (does not equal)
AND Industry Code =" "
SUM(Amount)
Any Ideas on how I can tackle this would be highly appreciated
Thank you in advance for your time
Mark
Am I the only one or are there others who experience the same problem:
in a set analysis, if using -= or *= the intelisense (autocomplete) stops working.
Thanks
Josh Duenyas
Hi Mate
I have a similar issue with if in the chart expression:
My requirement is basically this:
Chart Dimension: Mth (like Jan, Feb , ...)
For Current month comparing due date of each ID with Today() and counting the overdued IDs
For past months, comparing the due date of each ID with LastDayOfTheMonth (Which is a master calendar field date I added)
This is my expression which is not working:
If (Mth=date(Today(),'MMM'), Count( {<DueDate={"<=$(=Today())"}>} Comp_ID),Count( {<DueDate={"<=$(=LastDayOfTheMonth)"}>} Comp_ID ))
>>the intelisense (autocomplete) stops working.
That was a problem on versions of QV prior to 11.20 SR7 or SR8 (I think that was about 2 years ago). You may want to upgrade to a more recent version.
Hi Jonathan,
Hope you're well. Could you please have a look at my expression :
My requirement is basically this:
Chart Dimension: Mth (like Jan, Feb , ...)
For Current month comparing due date of each ID with Today() and counting the overdued IDs
For past months, comparing the due date of each ID with LastDayOfTheMonth (Which is a master calendar field date I added)
This is my expression which is not working:
If (Mth=date(Today(),'MMM'), Count( {<DueDate={"<=$(=Today())"}>} Comp_ID),Count( {<DueDate={"<=$(=LastDayOfTheMonth)"}>} Comp_ID ))
Its not a good idea to hijack a thread with another question. Please open a new thread with your question.