topic Re: Split Rows in QlikView

Split Rows

sat_tok52 — Tue, 07 Apr 2015 12:25:45 GMT

Thanks All,

Actually my requirement is we calculating %lean value by using line chart.We have 3000 records in our measure Column. Instead of Showing 3000 record in x-axis.We are Merge 30 records one Data Point and Next 30 records one Data point etc....

Please see the Attached Screen Show X-axis have numerical values each numerical value contains 30 records

Re: Split Rows

Tue, 07 Apr 2015 12:27:51 GMT

Hi Sateesh,

not really sure of your required output, can you knock up an example and post, would be easier to help then

Joe

Re: Split Rows

Roop — Tue, 07 Apr 2015 12:45:13 GMT

If this is your data .....

data:

LOAD * INLINE [

PRODUCT, YEAR, SALES

1, 2013, 12

2, 2013, 300

3, 2013, 400

4, 2013, 500

5, 2013, 600

6, 2013, 600

7, 2014, 500

8, 2014, 400

9, 2014, 300

4, 2014, 200

5, 2014, 100

9, 2014, 900

];

Use some kind of syntax like this to create the N records that you require. You can obviously change the first statement to include the RecNo() statement also.

load PRODUCT as PROD,

YEAR as YR,

SALES as SLS

Resident data

where RecNo() < 5

;

Re: Split Rows

sat_tok52 — Tue, 07 Apr 2015 13:25:11 GMT

Thanks All,

Re: Split Rows

sat_tok52 — Tue, 07 Apr 2015 13:25:46 GMT

Thanks All,

Re: Split Rows

sibideepak — Tue, 07 Apr 2015 13:29:24 GMT

Hi Sateesh,

According to your requirement ,how do you want to name every 30 records which isn't meaningless acutually,

Else you can create like Range in the Dimension and use your measure.

Can you post your sample data ?

Re: Split Rows

Roop — Tue, 07 Apr 2015 13:33:48 GMT

Probably use IntervalMatch in some form .... Keep the record number when you load the data and generate a small table that will create an intervalmatch input of 1 to 30, 31 to 60 etc.

Re: Split Rows

Tue, 07 Apr 2015 13:44:16 GMT

You can use the Class function in a Calculate Dimension like:

=Class(RowId_Num,5)

where RowId_Num matches RowNo() of records.

You can create your RowId_Num during data load.