Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
aryanreddy
Contributor II
Contributor II

Create a calculated field based on column

Hi everyone

I am new to qliksense i have a column named trainer id as from 1 to 10,now i would like to create claculaetd column based on trainer id as the calculated column should display '1' for trainer id 1,3,4,7,8 and for remaining it should display 0 how can i create a calcualted column for that please help me.

4 Replies
MarioCenteno
Creator III
Creator III

You could show the structure of your data and explain your goal a little more.

aryanreddy
Contributor II
Contributor II
Author

trainer Id.JPG

I have a trainer id from 1 to 10 like above for 20,000 employee, I would like to create a new calculated column with 0 and 1 for trainer id 1,3,4,7,8 it should display 1 for remaining it should display 0.

MarioCenteno
Creator III
Creator III

Try

=if([ID] = 1 OR [ID]= 3 OR [ID]= 4 OR [ID]= 7 OR [ID]= 8,1,0)

ChennaiahNallani
Creator III
Creator III

try like below

Script

If(Match(ID,1,3,4,7,8), 1, 0) as FieldName

ui

If(Match(ID,1,3,4,7,8), 1, 0)