topic Re: How to use ColumnNo() in expression in App Development

How to use ColumnNo() in expression

dotnetfan — Sat, 16 Nov 2024 03:19:46 GMT

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!

Re: How to use ColumnNo() in expression

Gysbert_Wassenaar — Sun, 09 Feb 2020 14:27:24 GMT

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/InterRecordFunctions/columnno.htm

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

Re: How to use ColumnNo() in expression

BinayKumarSah — Sun, 09 Feb 2020 16:32:08 GMT

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