Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Creating a calculated column with an if statement

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

7 Replies

Re: Creating a calculated column with an if statement

You do have that options. Check here:

Calculated Dimensions

Calculated dimensions ‒ Qlik Sense

Not applicable

Re: Creating a calculated column with an if statement

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?

Re: Creating a calculated column with an if statement

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)

Capture.PNG

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

Re: Creating a calculated column with an if statement

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

Creating Dimensions and Measures

Not applicable

Re: Creating a calculated column with an if statement

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.

Re: Creating a calculated column with an if statement

Not sure I understand what you are trying to say

Not applicable

Re: Creating a calculated column with an if statement

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 creatorCapture.PNGCapture2.PNG

Community Browser