topic How to merge two rows data in straight table? in QlikView

How to merge two rows data in straight table?

Thu, 24 Sep 2015 11:45:58 GMT

HI,

I have data in straight table as below

how to merge tow same READ rows so, I need out put as below

READ	MonthYear	Enter	Gone	Ready
Stats	Jan 2013	5	3	2

please can anyone suggest me how to do this?

Thanks.

PrashantSangle — Thu, 24 Sep 2015 11:49:02 GMT

Hi,

take Read and MonthYear as dimension and

Write expression for

Sum(Enter) for Enter

Sum(Gone) for Gone

sum(Ready) for Ready

Regards

maxgro — Thu, 24 Sep 2015 11:53:09 GMT

it sholud be already merged in a str table chart with 2 dimensions and 3 (sum) expressions

or I'm missing something?

maybe you have 2 different date on the same month in a calculated dimension formatted as MMM YYYY?

use =Date(MonthStart(datefield), 'MMM YYYY')