Discussion board where members can get started with Qlik Sense.
I have a simple problem with a complex solution.
I have a field called Codes and it is in an alphanumeric format.
For example. A0000756
Each code has a value associated with it called Value.
For example: A0000756
Value = 76
Now someone has consolidated a range of Codes together.
For example: A0000756-A0000852
I want to split this range in the load editor individually and divide the sum of Value by the count (which is 852-756=96) .
Any suggestion will help
If i undsertood your requirement , is this what you;'re looking for
Load if(index(Code,'-'),subfield(Code,'-',2)-subfield(Code,'-',1),Value)as Value,
CVV as Code;
Load PurgeChar(CVV,'ABCDEFGHIJKLMNOPQRSTUVWXYZ') as Code,Value,CVV;
Load * INLINE
May be Use Dual to create your field