Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get Multiple data in one single row.

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.

5 Replies
swuehl
MVP
MVP

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

michaelfreitas
Creator
Creator

Hello

This helps?


Load

CalendarYear,

CalendarMonth

sum(Danish) as Danish,

.

.

.

from..

group by CalendarYear, CalendarMonth

Not applicable
Author

Hi,

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

swuehl
MVP
MVP

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

Not applicable
Author

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