Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum Measure Column Values into Texbox when rowno() used

Hi All,

I'm probably not using the right search criteria as I can't find how to Sum the values of a Measure column (in a Table)  into a textbox when I have used the RowNo() function to calculate the values.

Here's the scenario, when visiting a client to fix a system the 1st system (row)  costs a set amount and includes fixing 5 widgets, any subsequent systems fixed have a reduced cost which includes fixing 2 widgets.

The formula.for the measure column is :

=if(rowno(total) = 1,

250 + (if([Total No of widgets] > 5, ([Total No of widgets]-5)*25, 0)),

80 + (if([Total No of widgets] > 2, ([Total No of widgets]-2)*25, 0))

)

Any pointers appreciated.

Thanks,

Dog.

1 Reply
sunny_talwar

RowNo() is in context of a chart... a text box can only have a single row... either use Aggr() to create a virtual table... use another criteria to differentiate between 1st row vs other rows