topic ? in QlikView

?

xyz1 — Sun, 14 Apr 2019 14:05:16 GMT

Re: conditional count

rahulpawarb — Tue, 02 May 2017 04:57:55 GMT

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/CounterAggregationFunctions/NullCount.htm

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

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 — Sun, 14 Apr 2019 14:04:35 GMT

Re: conditional count

jonathandienst — Tue, 02 May 2017 05:21:00 GMT

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.

Re: conditional count

rahulpawarb — Tue, 02 May 2017 05:25:30 GMT

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

Regards!

Rahul