1 Reply Latest reply: Jan 1, 2018 3:56 PM by Bill Markham RSS

    how can i split a straight table with 50 records result into 2 straight tables?

    Amien Amien

      I have this straight table in Qlik Sense:


      Date, Name


      This gives me 50 records.

      Now i want to create two straight tables : one which shows me the first 25. And the other Straight table should show the other 25 records.


      I tried with this:


      If(RowNo() > 0 And RowNo() <= 25,RowNo()) and then a "Include Null Values" Unchecked .. this works fine .. but i don't want to create another column, just for this (space is limited)


      If(RowNo() > 0 And RowNo() <= 25,Name) Also doesn't work.


      Anyone got other ideas? Otherwise i have to load a special table for this, which puts the RowNo into the datamodel.


      Thanks in advanced