topic Re: Merging data in QlikView

Merging data

Anonymous — Tue, 27 Oct 2015 06:29:51 GMT

I need to merge data in pivot table, for example:

Grade "A" + Grade "CYA" = A+

Grade "B" + Grade "CYB" = B+

i want to merge all value in one expression.

i use this expression:

=if(Grade = 'A', 'A+',if(Grade='CYA','A+',if(Grade <> '', PurgeChar (Grade,''))))

to merge only one value A + CYA = A+

Gysbert_Wassenaar — Tue, 27 Oct 2015 06:40:00 GMT

I need to merge data in pivot table, for example:

Grade "A" + Grade "CYA" = A+

Grade "B" + Grade "CYB" = B+

Create a new field in the script that links the original grades to your new grades:

Grades:

LOAD * INLINE [

ReportGrade, Grade

A+, A

A+, CYA

B+, B

B+, CYB

...etc

];

Then use the new field ReportGrade as dimension in your bar chart.

jagan — Tue, 27 Oct 2015 07:07:13 GMT

Hi,

Change you script like below

LOAD

if(Grade = 'A', OR Grade='CYA','A+',

if(Grade = 'A', OR Grade='CYB','D+', Grade)) AS New_Grade

FROM DataSource;

Now use the new column New_Grade in dimension, this will merge the data as you expected.

Regards,

Jagan.

ahmar811 — Tue, 27 Oct 2015 07:47:49 GMT

Write condition on Dimension like that for all grade

if(Grade = 'A' or Grade='CYA','A+',

if(Grade = 'A-' or Grade='CYA-','A-',

if(Grade = 'B-' or Grade='CYB-','B-',

if(Grade = 'B' or Grade='CYB','B',

if(Grade = 'B+' or Grade='CYB+','B+',

if(Grade = 'C' or Grade='CYC','C',Grade

))))))

i implemented on qvw file also

hope these help you