Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
ramrongala
Contributor II
Contributor II

How add 2 filed values and add new field value in straight table

Hi All

I have some issue in straight table. i got below table in QV

desk.png

But user wants like below one:

desk1.png

4 field values we need add this table

1) non land Total= Debenture+Guarantee+others    2) non os overall= Debenture+Guarantee+others+land

3) non os land Total= OS Debenture+OS Guarantee+OS others 4) non os overall=OS Debenture+OS Guarantee+OS others+OS land

in sales expression avg of field values

count expression add of field count

so please help on this issue. kindly check attachment of QVW and EXcel.

1 Solution

Accepted Solutions
1 Reply