topic Split Rows in QlikView

Split Rows

sat_tok52 — Mon, 13 Apr 2015 08:35:54 GMT

Hi All ,

Thanks for your quick response. but it is not working as per my requirement.See below example I would like to generate my chart like this.In my chart x-axis showing 1 ,2 ,3 ,4 ,5 etc.I means (0-30 Rows) and 2 means (30-60 Rows) like that to show in my chart.

Regards,

Satish

Hi All,

I Have a column called ID it contains 100 rows.As per my Requirement my line chart to show the range of 0-30 rows 1Datapoint and 30-60 2Datepoint and 60-90 3Datapoint because we considering each 30 rows one datapoint ,and also rest of 10 rows i don't want to show in my chart.

ID	%Value
0-30	63.00%
30-60	75.35%
60-90	85.55%

I am using Class function like Class(ID,30) but it is displaying last last 10 rows percentage also.

Regards,
Satish

Re: Split Rows

MK_QSL — Mon, 13 Apr 2015 08:41:33 GMT

Go to your Expression Tab

and use something like similar

COUNT({<ID = {"<=90"}>}FieldName)

Or Change your Calculated Dimension as below

=CLASS(IF(ID<=90,ID), 30)

Tick Suppress When Value is Null

Edit : Changed 90 instead of 60 to get data upto ID 90

Re: Split Rows

mrossoit — Mon, 13 Apr 2015 08:46:18 GMT

Try this

Regards

Re: Split Rows

sat_tok52 — Mon, 13 Apr 2015 09:03:03 GMT

Hi Rosso,

Re: Split Rows

sat_tok52 — Mon, 13 Apr 2015 09:04:35 GMT

Hi Manish,

Regards,

Satish

Re: Split Rows

mrossoit — Mon, 13 Apr 2015 09:07:25 GMT

Try to define your ID classes in the script and use that new field as dimension of your chart.

Re: Split Rows

sat_tok52 — Mon, 13 Apr 2015 09:30:37 GMT

Hi Manish,

Regards,
Satish

Re: Split Rows

sat_tok52 — Mon, 13 Apr 2015 09:31:08 GMT

Hi Rosso,

Re: Split Rows

mrossoit — Mon, 13 Apr 2015 10:02:49 GMT

Try it now.

Re: Split Rows

Anonymous — Mon, 13 Apr 2015 10:21:18 GMT

can you share your QVW.

Re: Split Rows

MK_QSL — Mon, 13 Apr 2015 11:23:47 GMT

=IF(ID > 0 and ID <=30, '1',

IF(ID > 30 and ID <=60, '2',

IF(ID > 60 and ID <=90, '3')))

Re: Split Rows

sat_tok52 — Mon, 13 Apr 2015 11:36:06 GMT

Thanks for your reply.But I don't want to take Static it should be dynamic.