How to use ColumnNo() in expression

[dotnetfan]

I have one question about how to minus ColumnNo() in my following expression:

If(RowNo() = 3,
If(ColumnNo() < $(CurrentMonth),
Sum([BP.Value])
,Text(Above( Sum( [BP.Value] )) - Sum( [BP.Value]))&'/'&
Text(ONLY({<BestWorst.Month = {"$(=CurrentMonth * 2 - 1)"}, [BestWorst.Year] = {"$(=Best)"}>}BestWorst.Value))
&'/'&Text(ColumnNo())
),Sum([BP.Value]))

I have tried: {<BestWorst.Month = {"$(=CurrentMonth * 2 - 1 - ColumnNo())"} but it doesn't work...

Please help me, thanks!

[Gysbert_Wassenaar]

ColumnNo() returns the index number of the dimension or expression in a pivot table.

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

Can you explain in more detail what you're trying to do? An example app would help.

[BinayKumarSah]

Please refer this link we have solution in community:-
https://community.qlik.com/t5/New-to-QlikView/What-is-NoOfColumn-and-Column-No/td-p/859720