First non zero value from each row as column name in table - Qlik Sense

[mramitbhandari17]

Get first fieldname name with a value condition

Hi All, I want to have a new column on a table that gives me the first column that has a specific value.

So, I have this

Header 1 Header 2 Header 3 Header 4 Header 5

Name Month1 Month2 Month3 Month4

A 0 0 3 3

B 0 4 0 1

C 0 3 2 1

D 1 0 0 1

I would like to add a column with the name of the first column that has a value higher than 0.

Header 1 Header 2 Header 3 Header 4 Header 5 Header 6

Name Month1 Month2 Month3 Month4  FirstMonthSales

A 0 0 3 3

Month3 B 0 4 0 1

Month2 C 0 3 2 1

Month2 D 1 0 0 1

Month1

So, the FirstMonthSales column should have the first month that has a value higher than 0.

Kindly assist on this. if anyone

[Ajay_Ananthnarayan]

This might help you. Review the examples and results
https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inter...