Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 😃