Skip to main content
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: 
Yuhka
Contributor III
Contributor III

Get min Number of 18 digits number using Group by

Hello guys, I'm new to qlikview.

I have a data as follows, and I would like to get min number of 18 digits number by Group by Type.

キャプチャ1.PNG

 

 

 

However when I tried Group by, it was unable to get min number.

When I tried with 9 digits number, I could get min number correctly.

How can I get min number of 18 digits number using Group by?

I tried with Num() or Num#() expression, but it didn't go well...

Thank you for your big help!

 

Labels (3)
1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

Your number is a string value.. Use MinString or convert your string to a number

 

LOAD
MinString(Number) as Number_min,
Type
Resident Table1
Group by Type;

View solution in original post

2 Replies
sasiparupudi1
Master III
Master III

Your number is a string value.. Use MinString or convert your string to a number

 

LOAD
MinString(Number) as Number_min,
Type
Resident Table1
Group by Type;

Yuhka
Contributor III
Contributor III
Author

@sasiparupudi1 

Thank you for your reply.

It worked perfectly! Thank you for your support!😀