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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Bhuvi
Partner - Contributor III
Partner - Contributor III

Numbers 2

How can I get this

Input Output
1 1
2 2
3 1
4 2
5 1
6 2
7 1
8 2
9 1
10 2
Labels (1)
1 Solution

Accepted Solutions
tresB
Champion III
Champion III

AutoNumber(Mod(RowNo(),2)) as Output

or

AutoNumber(Mod(Input,2)) as Output

View solution in original post

2 Replies
tresB
Champion III
Champion III

AutoNumber(Mod(RowNo(),2)) as Output

or

AutoNumber(Mod(Input,2)) as Output

settu_periasamy
Master III
Master III

Or

If (Odd(Input)= -1,1,2) as Output