Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Highlighted
Not applicable

sum of all the columns group by project name ?

I have  a table like this:


project_name      janExp      febExp      marchExp      aprilExp

project A           1000           1100          1200              1300

project B           2000           2100          2200              2300

project C           3000           3100          3200              3300

project A           500             600            700                800

project B           100             200            300                400

I want output like this:

project_name          janExp      febExp      marchExp        aprilExp

Project A                1500           1700           1900             2100

Project B                2100           2300           2500             2700

project C                3000           3100           3200             3300

I am new to Qlikview,  can someone tell me what I need to do for it?

1 Reply
MVP & Luminary
MVP & Luminary

Re: sum of all the columns group by project name ?

You need to transform your data with The Crosstable Load

- Marcus