topic Re: ColumnNo() not working in the Pivot table in QlikView

ColumnNo() not working in the Pivot table

jduluc12 — Thu, 10 Feb 2022 07:41:52 GMT

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

Re: ColumnNo() not working in the Pivot table

anat — Thu, 10 Feb 2022 08:23:08 GMT

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/InterRecordFunctions/columnno.htm?_ga=2.185328161.922998907.1644470714-1952845469.1641552173

Re: ColumnNo() not working in the Pivot table

jduluc12 — Thu, 10 Feb 2022 08:41:45 GMT

thanks, that clarifies

Re: ColumnNo() not working in the Pivot table

Claude1 — Mon, 21 Feb 2022 04:26:06 GMT

@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.

Re: ColumnNo() not working in the Pivot table

kishak — Wed, 06 Dec 2023 18:09:06 GMT

Use the right-click menu to show the Pivot Table Field List.
It's likely that the right-click menu is the fastest way to get it back.
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.
This will bring back the field list's normal behavior and make it viewable again.

Thank You. kdealer plus