Discussion board where members can get started with QlikView.
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!
Go to Solution.
Your number is a string value.. Use MinString or convert your string to a number
LOADMinString(Number) as Number_min,TypeResident Table1Group by Type;
Thank you for your reply.
It worked perfectly! Thank you for your support!😀