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

mramitbhandari17 — Thu, 25 Jan 2024 06:05:26 GMT

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

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

Ajay_Ananthnarayan — Thu, 25 Jan 2024 07:25:09 GMT