Expression Problem

[#1]

Hi All,

I have file like below, and I would to count number keys between  201601 and 201603 based on the Account _Open_Date using If condition.

[Anil_Babu_Samineni]

What was the logic behind for 201601 and 201603 ??

[Anonymous]

Hello!

Try this: count({<Account_Open_Date={"$(= '>=' & '201601' & '<=' & '201603')"}>} key)

[jmvilaplanap]

Using Set Analysis:

• count({<Account_Open_Date={'201601','201602','201603'}>}Key)
  • Because this have not date format, then I don't know if you can use < or > symbols

Usign If is almost the same (but I'm not sure if it works)

• count(if(Account_Open_Date = '201601' or Account_Open_Date = '201602' or Account_Open_Date = '201603', Key)

[sunny_talwar]

Key can repeat?

If you want distinct count

Count(DISTINCT {<Account_Open_Date = {'>=201601<=201603'}>} Key)

If you want count

Count({<Account_Open_Date = {'>=201601<=201603'}>} Key)