?

[xyz1]

.

[rahulpawarb]

Hello Agrim,

Trust that you are doing good! First at script level set the null values to a deterministic value using below statement.

Set NULLINTERPRET = -1;

Post that, perform the the date difference operation to have date related criteria in place. Also to count null values you can make use of NullCount function.

References:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/CounterAggregationFunc...

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/CounterAggregatio...

Along with this to count those accounts whose password never exprires, you can draft an expression similar to below:

Count({<Role={'DISABLED', 'DISABLED\NO_PWDEXP', 'DISABLED\NO_PWDEXP\NO_PWDREQD', 'NO_PWDEXP', 'NO_PWDEXP\ENCRYPT', 'NO_PWDEXP\NO_PWDREQD', 'NO_PWDEXP\SMART', 'NO_PWDEXP\DELEGATE'}>Pre-W2KName}

Please correct me if I misinterpreted.

Hope this will be helpful.

Regards!

Rahul

[xyz1]

.

[jonathandienst · Accepted solution]

Perhaps this:

1. =NullCount({<[Last Logon TimeStamp = {"<=$(=Date(Today() - 30))"}>} Role)

2. =Count({<ROLE = {"*NO_PWDEXP*"}>} ROLE)

The case of Role is inconsistent in your post, so please change the above to the correct casing for Role. Remember QV is case sensitive for field names, so Role is not he same field as ROLE.

[rahulpawarb]

You can refer the inputs provided by jontydkpi . This will help you to get desired results.

Regards!

Rahul