Creating a calculated column with an if statement

[#1]

The only calculation options I see when I try to create a new calculated column are arithmatic calculations such as + - etc. I need to create it using an if statement

[sunny_talwar]

You do have that options. Check here:

Calculated Dimensions‌

Calculated dimensions ‒ Qlik Sense

[#3]

Thanks. I was able to create calculated fields based on your second link. Now I need to create a pivot table. How do i create a pivot table based on the table I just created with the calculated columns?

[sunny_talwar]

There is an object type -> Pivot table. You need to use that to create a pivot table. A regular table cannot be converted to Pivot table (at least that's what I know based on my limited knowledge of Qlik Sense)

Update: You should be able to copy paste your calculated dimension to the pivot table

[sunny_talwar]

Or look here to create master dimension (and also master expressions)

Creating Dimensions and Measures

[#6]

Thanks. I am using that object pivot table to create a pivot table. It is just that I want that pivot table to get the fields from these calculated fields but I am not able to.

[sunny_talwar]

Not sure I understand what you are trying to say

[#8]

check out my first picture. Those are the calculated fields i created.

Check out the second picture. They do not appear in this pivot table creator