Discussion Board for collaboration regarding Qlik DataMarket.
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.
Maybe using an expression like
=Rowno(TOTAL) *2 -1
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
It resolved the problem.