topic load exact same rows in QlikView

load exact same rows

Thu, 15 Apr 2010 08:41:18 GMT

Goodmorning,

I have a question. I want to read information out of a table that can contain exact the same rows for one Ordernumber (ORRGF2). For example:

BTCHF2	BTCHF2@	BTWBF2	BTWCF2	BTWPF2	CDEKF2	DCNRF2	EKBDF2	FKNRF2	FKVLF2	FKVLF2@	OSRTF2	PEURF2	PNLGF2	REGNF2	VESTF2	ORRGF2
14318	0	0,00	GD2	0,00	LSD	1661471	17,00	1121173	860	0	109	17,00	17,00	60	1	1260126
14318	0	0,00	GD2	0,00	LSD	1661471	17,00	1121173	860	0	109	17,00	17,00	60	1	1260126
14318	0	0,00	GD2	0,00	LSD	1661471	17,00	1121173	860	0	109	17,00	17,00	60	1	1260126
14318	0	0,00	GD2	0,00	LSD	1661471	17,00	1121173	860	0	109	17,00	17,00	60	1	1260126

If I select (load) these rows without any group by or order by function into Qlikview, I only get 1 of these rows.

BTCHF2	BTCHF2@	BTWBF2	BTWCF2	BTWPF2	CDEKF2	DCNRF2	EKBDF2	FKNRF2	FKVLF2	FKVLF2@	OSRTF2	PEURF2	PNLGF2	REGNF2	VESTF2	ORRGF2
14318	0	0,00	GD2	0,00	LSD	1661471	17,00	1121173	860	0	109	17,00	17,00	60	1	1260126

It seems that Qlikview handles this as one unique and the same row, because they are all exact the same. But I need all four rows!
How can I solve this in Qlikview?

Best regards,

Johann

load exact same rows

Thu, 15 Apr 2010 08:45:49 GMT

hi,

you can include one additional field " index" in your table as follows

load rowno() as index

this should work fine now

thanks

load exact same rows

d_pranskus — Thu, 15 Apr 2010 08:48:09 GMT

It is because the way QV displays data - If all values in the displayed fields are the same for each row, QV shows the row once. Actually there is all the rows in memory. You can check it by createing a chart which agregates the data to see the exact measures. Or Go to Table viewer and prevewiew the data

load exact same rows

Thu, 15 Apr 2010 08:52:32 GMT

This isn't true in this case. I see only one row, but the aggregation is also based on that one row.

Note: I select the data with SQL, not with the Load function within Qlikview.

load exact same rows

Thu, 15 Apr 2010 08:54:59 GMT

hi,

you can include one additional field " index" in your table as follows

load rowno() as index

and then use index as a dimension in your pivot table or a straight table to display all four rows

thanks

load exact same rows

d_pranskus — Thu, 15 Apr 2010 09:04:30 GMT

I loaded the data from your example into QV, and as you can see, TableBox shows just one row, but if you create a chart (straight table) and create an expression, you can see that actualy all rows are present. See PEURF2 field the value for each row is 17, but in expresion there is 68.

If you need to display each row - you must have an ID as tauqueer suggested.

Cheers

DArius

load exact same rows

Thu, 15 Apr 2010 13:21:07 GMT

Thanks guys, the problem is solved now, but I had to put a SUM statement in my query to solve this problem. Now the report on the table is correct.

Regards,

Johann