Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Odd even row number for the straight tablet

I want to create straight table with odd or even numbers.row numbers.

Means, for a table chart, i want the numbers in sequence like 1,3,5,7.........etc.

Thanks in advance.

4 Replies
MVP
MVP

Re: Odd even row number for the straight tablet

Maybe using an expression like

=Rowno(TOTAL) *2 -1

MVP
MVP

Re: Odd even row number for the straight tablet

You can also add another calculated dimension in your straight table:

=Aggr(If(Mod(RowNo(TOTAL), 2) = 1, RowNo(TOTAL)) , Dim)

and select 'Suppress When Value Is Null' option on the dimension tab

Capture.PNG

Not applicable

Re: Odd even row number for the straight tablet

Thanks, swuehl.

It resolved the problem.

Not applicable

Re: Odd even row number for the straight tablet

Thanks Sunny

Community Browser