Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
omerkorayerguder
Contributor II
Contributor II

Script Placement

How is a placement like 1.1 or 1.1.1 done on the qlik sense script side?

Labels (2)
5 Replies
TauseefKhan
Creator III
Creator III


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.******** 


omerkorayerguder
Contributor II
Contributor II
Author

hi tauseff,

thanks a lot for your answer, but i need like this

omerkorayerguder_0-1717499356261.png

 

TauseefKhan
Creator III
Creator III

On which condition you creating this new column?

omerkorayerguder
Contributor II
Contributor II
Author

I want to do it by IDS_Short  column

omerkorayerguder
Contributor II
Contributor II
Author

can anyone help me 😃