Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amien
Valued Contributor

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

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

1 Solution

Accepted Solutions

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

The attached seems to work for me.

1 Reply

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

The attached seems to work for me.

Community Browser