topic Re: Expression Problem in QlikView

Expression Problem

Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 05 Jul 2017 08:58:43 GMT

What was the logic behind for 201601 and 201603 ??

Anonymous — Wed, 05 Jul 2017 09:04:32 GMT

Hello!

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

jmvilaplanap — Wed, 05 Jul 2017 09:10:44 GMT

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 — Wed, 05 Jul 2017 12:04:00 GMT

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)