topic How to get Multiple data in one single row. in QlikView

How to get Multiple data in one single row.

Mon, 18 Jul 2011 21:17:04 GMT

Hi all,

I have a chart using set analysis in the expressions to discard the date selection.

Table1
CalendarYear	CalendarMonth	Danish	Dutch	Finnish	French	German	Italian	Norwegian	Spanish	Swedish	UK English	Polish	Russian	GriefReports
		-	-	-	-	-	-	-	-	-	-	-	-	195
2010	7	-	-	-	-	-	-	-	-	-	-	-	-	1
2010	7	-	-	-	9	-	-	-	-	-	-	-	-	9
2010	7	-	-	-	-	-	20	-	-	-	-	-	-	20
2010	7	-	-	-	-	-	-	-	21	-	-	-	-	21
2010	7	-	-	-	-	-	-	-	-	-	54	-	-	54
2010	7	-	-	-	-	90	-	-	-	-	-	-	-	90
Table 2
What I want is:

CalendarYear	CalendarMonth	Danish	Dutch	Finnish	French	German	Italian	Norwegian	Spanish	Swedish	UK English	Polish	Russian	GriefReports
		-	-	-	-	-	-	-	-	-	-	-	-	195
2010	7	-	-	-	9	90	20	-	21	-	54	-	-	1

I see all the data I'm expecting to see in the table1. The set analysis expressions work fine in the table. But it is showing multiple rows (Table1) for the month of July, I wanted to retrieve all data in one row. See table 2. To do this what sort of expression do I need? I think, i have to discard the grief report to get one single row information. Any idea you could share.............? Thanks.

How to get Multiple data in one single row.

swuehl — Mon, 18 Jul 2011 21:24:22 GMT

Hi chowdhury,

it would be good if you could post an example qvw, that makes it a lot easier for us to understand and help.

If this is not feasible, then please post the expressions (I think there is a substantial difference between the languages and grief report, so if this is the case, please post a language example expression and the grief report expression).

Cheers,

Stefan

How to get Multiple data in one single row.

michaelfreitas — Mon, 18 Jul 2011 22:03:25 GMT

Hello

This helps?

Load

CalendarYear,

CalendarMonth

sum(Danish) as Danish,

from..

group by CalendarYear, CalendarMonth

How to get Multiple data in one single row.

Tue, 19 Jul 2011 08:57:03 GMT

Hi,

i have attached qvd file. NB: for data, i have used Excel file. thanks

How to get Multiple data in one single row.

swuehl — Tue, 19 Jul 2011 09:37:45 GMT

Your second message today seems to be deleted from the thread, couldn't find the attachment.

How to get Multiple data in one single row.

Tue, 19 Jul 2011 10:16:51 GMT

hi, i have figure it out. sum({$} Mod_Moderated) thanks anyway.