topic Re: Where is my mistake, in QlikView

Where is my mistake,

vmonitor — Wed, 25 Nov 2020 16:16:04 GMT

Could you help me to find my mistake please.
=count({<час_минута={'=$(=min(час_минута))'}>} [Call ID]) I have got 0
min - '10:55'
=count({<час_минута={'10:55'}>} [Call ID]) I have got 9298

Re: Where is my mistake,

Simon_Astakhov — Wed, 03 Jul 2019 10:38:54 GMT

Hi!

Min() function return Numeric type of data. Try to convert it to required format again? like:

=count({<час_минута={"=$(=time(min(час_минута),'hh:mm'))"}>} [Call ID])

=count({<час_минута={"=$(=text(time(min(час_минута),'hh:mm')))"}>} [Call ID])

or not use dollar sign

=count({<час_минута={'=min(TOTAL час_минута)'}>} [Call ID])

or use boolean expression

=count({<час_минута={'=[час_минута]=min(TOTAL час_минута)'}>} [Call ID])

And check [час_минута] field is numeric.

Re: Where is my mistake,

sasiparupudi1 — Wed, 03 Jul 2019 14:57:26 GMT

If the value is a string in час_минута,

=count({<час_минута={'=$(=MinString(час_минута))'}>} [Call ID])

Re: Where is my mistake,

vmonitor — Thu, 04 Jul 2019 06:46:15 GMT

This one is woking :-). Thanks

=count({<час_минута={'=[час_минута]=min(TOTAL час_минута)'}>} [Call ID])