Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How is a placement like 1.1 or 1.1.1 done on the qlik sense script side?
Create Calculated Fields for Hierarchical Numbering or Create New Field:
YourTable:
LOAD
*,
RowNo() as CategoryNumber,
RowNo() & '.' & RowNo() as CategorySubNumber,
RowNo() & '.' & RowNo() & '.' & RowNo() as CategorySubSubNumber
FROM data_source;
In the above example:
CategoryNumber represents the first level (e.g., “1”).
CategorySubNumber represents the second level (e.g., “1.1”).
CategorySubSubNumber represents the third level (e.g., “1.1.1”).
or
YourTableName:
Load *,
'1.1' As Your_FieldName
From data_source;
*****Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.********
hi tauseff,
thanks a lot for your answer, but i need like this
On which condition you creating this new column?
I want to do it by IDS_Short column
can anyone help me 😃