Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

dogeronkelly
New Contributor II

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.

Tags (2)
1 Reply

Re: Sum Measure Column Values into Texbox when rowno() used

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

Community Browser