IF AND Expression

[#1]

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

[jduenyas]

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

[arixooo123]

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

[jonathandienst]

>>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.

[arixooo123]

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

[jonathandienst]

Its not a good idea to hijack a thread with another question. Please open a new thread with your question.