how can i add up the rows in a straight table?

[#1]

in this image i want RA, SV AND DMIN to be sum as AD Total

and AUTO, WA, MF as MF/WA.

How can i achieve it

[Oleg_Troyansky]

I'd suggest to create another field in your database and build the corresponding associations there. Then, use that new field as a dimension in the straight table.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[sinanozdemir · Accepted solution]

I can think of two ways:

First way:

If(Wildmatch(CBU, 'RA', 'SV', 'DMIN'), Sum(Q1 or your fact) and name  this expression as AD Total so this will be your column.

If(Wildmatch(CBU, 'AUTO', 'WA', 'MF'), Sum(Q1 or your fact) and name this expression as MF/WA so this will be another column.

Or you can group your dimension:

If(Wildmatch(CBU, 'RA', 'SV', 'DMIN'), 'AD', If(Wildmatch(CBU, 'AUTO', 'WA', 'MF'), 'MF/WA', CBU)

Hope this helps