Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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
1 Reply