Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Yuhka
New 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
Honored Contributor III

Re: Get min Number of 18 digits number using Group by

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;

2 Replies
sasiparupudi1
Honored Contributor III

Re: Get min Number of 18 digits number using Group by

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
New Contributor III

Re: Get min Number of 18 digits number using Group by

@sasiparupudi1 

Thank you for your reply.

It worked perfectly! Thank you for your support!😀