Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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;
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;