topic Merge Row and value in Charts/Straight Table in QlikView

Merge Row and value in Charts/Straight Table

Tue, 10 Feb 2015 13:27:20 GMT

Hi All,

In my Dash board i have a chart and Straight table in that i need to merge two rows and i need to show as single row.

Exampl

need to merge Inquiry and Service as a single column Like "Cases" and Do the Sum of the two rows.

Cases = Inqiry and Service.

How can i do this...Please help .

Tue, 10 Feb 2015 13:43:04 GMT

Hi,

You can get it done by writing condition in dimension.

PFA

Warm Regards

Joshmi

maxgro — Tue, 10 Feb 2015 13:47:42 GMT

or yoy can add a calculated field and use it as dimension

load

if(match(ServiceType, 'Inquiry', 'Service'), 'Cases', ServiceType) as ServiceTypeGroup;

LOAD * INLINE [

ServiceType, Vol1, Vol2

Inquiry, 15522, 4522

Service, 1271, 6354

Other Service, 963, 123

Unclassified, 75, 12

];

robert_mika — Tue, 10 Feb 2015 13:49:17 GMT

Hi Joshmi,

Would you mind to share your solution?

I'm using Personal edition.