Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
vmonitor
Contributor III
Contributor III

Where is my mistake,

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

1 Solution

Accepted Solutions
vmonitor
Contributor III
Contributor III
Author

This one is woking :-). Thanks

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

View solution in original post

3 Replies
Simon_Astakhov
Partner - Contributor III
Partner - Contributor III

Hi!

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

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

or

=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.

sasiparupudi1
Master III
Master III

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

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

vmonitor
Contributor III
Contributor III
Author

This one is woking :-). Thanks

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