ColumnNo() not working in the Pivot table

[jduluc12]

Hi,

I am using a simple expression in the pivot table with one dimension, which is something like as follows.

if (ColumnNo() = 1, 1, 0)

but it seems the ColumnNo() is not returning anything.

Am I missing anything here?

Jean

[anat]

you should have horizontal column in pivot table to use columnno() function.

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inter...

[jduluc12]

thanks, that clarifies

[Claude1]

---

@KDealer Support wrote:

Hi,

I am using a simple expression in the pivot table with one dimension, which is something like as follows.

if (ColumnNo() = 1, 1, 0)

but it seems the ColumnNo() is not returning anything.

Am I missing anything here?

Jean

---

The figure below summarises some common pivot table functions and what they do when you apply them to a given field. In this example, the centre field “Starting Point” will serve as our given field and be used as the starting point for each function. The figure then shows where in the table the data will be retrieved from depending on which function is applied.

[kishak]

1. Use the right-click menu to show the Pivot Table Field List.
2. It's likely that the right-click menu is the fastest way to get it back.
3. To see the field list, right-click on any cell in the pivot table and choose Show Field List from the menu that comes up.
4. This will bring back the field list's normal behavior and make it viewable again.

Thank You. kdealer plus