Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

I want add Value '0' to SampleNo .

I use code

Suchanan_0-1675736006102.png

result

Suchanan_1-1675736054722.png

This is Field SampleNo 

Suchanan_2-1675736152773.png

I want add Value '0' to SampleNo and 

Bring workoder to connect SampleNo which has added 0 .
I use the code but it gives error.

Suchanan_3-1675736978029.png

 

 

 

17 Replies
Sxbbb
Creator III
Creator III
Author

I try Code but it error 

Suchanan_0-1675738905756.png

 

MayilVahanan

Are you looking to display Zero when SampleNo is blank? If so, try like below..


=WorkOrder&'-'&Alt(SampleNo,0)

 

If not, can you elaborate your requirement in detail?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Sxbbb
Creator III
Creator III
Author

Want WorkOrder&'-'&0 to divide WorkOrder into each WorkOrder.
for example WorkOrder&'-'&SampleNo
11111-0
11111-1
11111-5
11111-7
11111-8
22222-0
22222-1
22222-3
22222-5
33333-0
33333-1
33333-2
33333-3
but SampleNo not have Value '0'

Suchanan_0-1675741289574.png

 

 
Sxbbb
Creator III
Creator III
Author

Require WorkOrder&'-'&0 to split each next WorkOrder. 

by value
WorkOrder&'-'&0 equals 0
MayilVahanan

Try like below

Load * Inline
[
Dim
1
2
];

Calculated Dim:

=if(Dim = 1, [WorkOrder] &'-'& SampleNo, [WorkOrder]&'-'&0)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Sxbbb
Creator III
Creator III
Author

Result  

Suchanan_0-1675743324162.png

 

barnabyd
Partner - Creator III
Partner - Creator III

I think this is what you're looking for ...

=WorkOrder&'-'&num(SampleNo,'0#')
Barnaby Dunn
BI Consultant
Sxbbb
Creator III
Creator III
Author

I would like

Suchanan_2-1675743715015.png

 

barnabyd
Partner - Creator III
Partner - Creator III

What are the input values? I.e. what are the values of WorkOrder and SampleNo for each of these rows?

Barnaby Dunn
BI Consultant